black

1z0-043

登录

多项选择题

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

相关考题

单项选择题 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?()

单项选择题 You observe that database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to, in order to determine the required size of the database buffer cache?()

多项选择题 You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario?()

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号:湘ICP备2020024380号-3