black

1z0-043

登录

单项选择题

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)

相关考题

单项选择题 View the Exhibit and examine the characteristics of the USERS tablespace.  You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented.  Which advisory component would you refer to, in order to find information about table fragmentation?()

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

多项选择题 WhatarethetwoadvantagesofRMANBlockMediaRecovery(BMR)overfile­levelrecovery?()

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号:湘ICP备14005140号-5

经营许可证号:湘B2-20140064