單項(xiàng)選擇題

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）

A. The SGA Tuning Advisor
B. The SQL Access Advisor
C. The SQL Tuning Advisor
D. The Memory Advisor

你可能感興趣的試題

When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）

A. To indicate the location of the auxiliary-instance online redo logs.
B. To indicate the location of the target database datafiles.
C. To indicate the location of the auxiliary-instance control file and online redo logs.
D. To indicate the location of the auxiliary-instance database datafiles.
E. This is not a valid parameter when duplicating a database.

單項(xiàng)選擇題

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS
which statement is true？（）

A. You cannot perform the TSPITR with the constraints enabled.
B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
C. You can perform TSPITR only on the USERS tablespace.
D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
E. The TSPITR will only be successful if the constraint is enabled.

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）

你可能感興趣的試題

When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）

When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS
which statement is true？（）