多項(xiàng)選擇題

What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）

A.Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.
B.You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.
C.Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.
D.Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.

你可能感興趣的試題

單項(xiàng)選擇題

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

A.Define user profiles and set the CPU_PER_CALL limit.
B.Define a SWITCH_TIME for a plan in the Resource Manager.
C.Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations.
D.Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.

多項(xiàng)選擇題

he Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command. This avoids the previous need of shutting down the instance in order to modify the components of the SGA， namely the buffer cache and shared pool components.
Which three statements are true for the Dynamic SGA feature？（）

A.A
B.B
C.C
D.D
E.E

What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）

你可能感興趣的試題

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）