当前位置:1Z0-007题库

问题:

[单选] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? ()

A . MERGE
B . INSERT
C . UPDATE
D . ADD
E . ENTER
F . You cannot enter the phone numbers for the existing employee records.

User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table:SQL> DELETE FROM trans WHERE tr_type=’SL’; Which statement is true regarding the DELETE command() It fails to delete the records because the records are locked in SHARE mode.。 It deletes the rows successfully because the table is locked in SHARE mode。 It fails to delete the records because the table is locked in EXCLUSIVE mode.。 It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.。 Case-insensitive sorts are always accent insensitive by default.() True。 False。 A customer has a Power 770 running an SAP ERP workload on AIX 7. It has a single partition with 12 cores and 48GB of memory and the CPU is underutilized at 46% with 1000 users. Memory utilization is at 80%. The number of users will increase to 1700, increasing memory utilization by 37%. Which of the following supports this requirement?() Active Memory Server。 Active Memory Sharing。 Active Memory Pooling。 Active Memory Expansio。 An administrator has been asked to look at the different types of Emulex host bus adapters that can be used in an x445 server.  From the following options, where can the most relevant information be found to assist in making a valid choice?() IBM Redbooks。 IBM Announcement Letters。 ServerProven website。 Configuration and Options Guide (COG)。 三相交流异步电动机采用能耗制动时,应采取的方法是()。 切断三相交流电源。 切断三相电源,并在定子二相绕组中通入交流电。 切断三相电源,并在定子二相绕组中通入直流电。 三相交流电源中任意两相反接。 You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? ()
参考答案:

  参考解析

本题暂无解析

在线 客服