多项选择题
Which three statements about performance analysis by SQL Performance Analyzer are true？（）
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
相关考题
-
单项选择题
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING -
单项选择题
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL>@utlu111i.sql Which statement about the execution of this script is true？（）
A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments. -
单项选择题
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）
A. a cumulative level 1 backup
B. a differential level 1 backup
C. a full backup
D. a whole backup
