单项选择题
You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
A. Memory Advisor
B. Segment Advisor
C. SQL Access Advisor
D. Automatic Workload Repository （AWR）
E. Automatic Database Diagnostic Monitor （ADDM）
点击查看答案
相关考题
-
单项选择题
Therewasmediafailureandyouneedtocheckthedatafilesforanyblockcorruption.Whichoptionwouldyouusetocreateareportonanycorruptionsfoundwithinthedatabase？（）
A. the DBNEWID utility
B. the DBVERIFY utility
C. the ANALYZE command
D. the RMAN REPORT command
E. the RMAN CROSSCHECK command
F. the CHECK_OBJECT procedure of the DBMS_REPAIR package -
多项选择题
ThelossofwhichtwotypesoffilesmayrequirearecoverywiththeRESETLOGSoption？（）
A. control files
B. password file
C. archived log files
D. system-critical data files for which all the redo entries are present
E. non-system-critical data files for which all the redo entries are present -
多项选择题
YouwanttousetheSQLTuningAdvisortogeneraterecommendationsforbadlywrittenSQLstatementsinyourdevelopmentenvironment.Whichthreesourcescanyouselectfortheadvisortoanalyze？（）
A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs
