black

1Z0-042

登录

单项选择题

You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()

A.Memory Advisors
B.Segment Advisors
C.SQL Tuning and Access Advisors
D.Automated Workload Repository (AWR)
E.Automatic Database Diagnostic Monitor (ADDM)

相关考题

单项选择题 Twodatabaseusers,JackandBill,areaccessingtheSupportCenterSTAFFtableoftheSupportCenterDBdatabase.WhenJackmodifiesavalueinthetable,thenewvalueisinvisibletoBill.WhichisthemodifiedvalueinvisibletoBill?()

多项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.YouhavesettheretentionperiodforAutomaticRepository(AWR)statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics?()

单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.Inaproductionenvironment,userscomplainabouttheslowresponsetimewhenaccessingthedatabase.YouhavenotoptimizedthememoryusageoftheOracleinstanceandyoususpecttheproblemtobewiththememory.Towhichtypeofobjectwouldyourefertodeterminethecauseoftheslowresponse?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064