当前位置:1Z0-052题库

问题:

[单选]

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()

A . It fails to delete the records because the records are locked in SHARE mode.
B . It deletes the rows successfully because the table is locked in SHARE mode
C . It fails to delete the records because the table is locked in EXCLUSIVE mode.
D . It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

You have included the following parameter setting in your server parameter file:       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true?()    All the *_AREA_SIZE parameters are ignored.。  The Automatic PGA Memory Management feature cannot be disabled.。  The total Program Global Area (PGA) memory cannot be manually increased above 800M.。  The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.。 retail company plans to consolidate 180 existing dual processor Xeon servers, all running a web server application on Windows Server 2003. They are planning consolidating to a single x3950 X5 running vSphere.Which of the following should be discussed with this customer? () Is the web content static or dynamic information 。 Consider two servers for redundancy and failover 。 What is the average CPU utilization of the existing web servers 。 Will the servers need a SCSI or Fibre Channel storage solutio。 Which TWO of the following tasks of system maintenance can be improved by using Remote Deployment Manager?() Deployment。 Software maintenance。 Driver updates。 Disposal。 Software inventory。 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。 GB7512--2006《液化石油气瓶阀》明确规定了瓶阀的结构型式必须是()拆卸式。 可;。 不可;。 都可以。

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()

参考答案:

  参考解析

本题暂无解析

在线 客服