You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

A

 Top SQL

B

 snapshots

C

 SQL Tuning sets

D

 index access path

E

 optimizer statistics

F

 materialized view logs

相关问题推荐

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  A、import the database from the last export

  B、restore all the members in the group from the last backup

  C、drop the lost member from the database， and then add a new member to the group

  D、restore all the database files from the backup， and then perform a complete recovery 

  E、restore all the database files from the backup， and then perform an incomplete recovery

  查看答案

• You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

  A、 V$BACKUP_CORRUPTION

  B、 V$COPY_CORRUPTION

  C、 V$DATABASE_BLOCK_CORRUPTION

  D、 RC_BACKUP_CORRUPTION

  查看答案

• You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table：       Due to limited space， some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement： SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP；   What will be the implication of executing this statement？（）

  A、  Only the WAREHOUSE_DETAILS table is recovered， and none of the dependent objects are recovered.

  B、  The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints， primary key constraint， and the referential integrity constraints.

  C、  The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.

  D、  The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.

  查看答案

• 以下程序不用第三个变量实现将两个数进行对调的操作，划线处应为()。 main() {int a，b； scanf(“%d%d”，&a，&b)； cin＞＞a＞＞b； tout＜＜“a＝”＜＜a＜＜“b＝”＜＜b； a＝a+b；b＝a-b；a＝______； cout＜＜“a＝”＜＜a＜＜“b＝”＜＜b＜＜end1； }

  A．a-Cb

  B．a-b

  C．b*a

  D．a/b

  查看答案

• A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

  A、 The database re-created the missing redo log files automatically.

  B、 The database continues to function normally with the existing files.

  C、 The database allows only queries， no other statements are allowed.

  D、 The database returns and error and the database instance shuts down.

  E、 The user sessions that generate redo logs are terminated automatically.

  查看答案