單項(xiàng)選擇題

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）

你可能感興趣的試題

單項(xiàng)選擇題

There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）

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

多項(xiàng)選擇題

The loss of which two types of files may require a recovery with the RESETLOGS option？（）

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

你可能感興趣的試題

There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）

The loss of which two types of files may require a recovery with the RESETLOGS option？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）