首页 > 计算机类考试> 计算机三级> 数据库
题目内容 (请给出正确答案)
[多选题]

在oracle数据库中,关于数据库ADDM说法正确的两项是()。

A.ADDM的分析结果存储在AWR报告中

B.如果需要,ADDM调用其他顾问,但不提供顾问建议

C.ADDM运行在mmon自动采集AWR快照之后

D.ADDM分析只提供诊断信息,但不提供建议

E.ADDM分析需要最近的4个AWR快照

查看答案
答案
收藏
如果结果不匹配,请 联系老师 获取答案
您可能会需要:
您的账号:,可能还需要:
您的账号:
发送账号密码至手机
发送
安装优题宝APP,拍照搜题省时又省心!
更多“在oracle数据库中,关于数据库ADDM说法正确的两项是(…”相关的问题
第1题
下面有关AutomaticDatabaseDiagnosticMonitor(ADDM)的描述中,哪两项是正确的?()

A.ADDM可以调用其它建议如果需要,但是不会产生推荐建议

B.ADDM是MMON进程在每次awr快照收集后自动运行

C.ADDM至少需要4个awr快照进行分析

D.ADDM分析结果存放在AutomaticWorkloadRepository中

E.ADDM仅提供诊断分析,不提供建议

点击查看答案
第2题
YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesth
atconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance?()

A.runSegmentAdvisor

B.runSQLTuningAdvisorontopSQLstatements

C.runtheAutomaticWorkloadRepository(AWR)report

D.runtheAutomaticDatabaseDiagnosticMonitor(ADDM)ontopSQLstatements

点击查看答案
第3题
WhichcomponentdoestheSQLTuningAdvisorNOTanalyzefortheSQLstatements?()

A.ADDM

B.AWR

C.CursorCache

D.SQLTuningSets

E.FlashRecoveryArea

点击查看答案
第4题
Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You
suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLAccessAdvisor

D.AutomaticWorkloadRepository(AWR)

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

点击查看答案
第5题
InanOracle10gdatabase,thein-memorystatisticsaregatheredatregularintervalsandusedtoperformgrowth-trendanalysisandcapacityplanningofthedatabase.Whichcomponentstoresthesestatistics?()

A.recoverycatalog

B.OracleEnterpriseManagerRepository

C.AutomaticWorkloadRepository(AWR)

D.Oracle10gEnterpriseManagerGridControl

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

点击查看答案
第6题
YouworkasadatabaseadministratorforSupportcenter.cn.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()

A.MemoryAdvisors

B.SegmentAdvisors

C.SQLTuningandAccessAdvisors

D.AutomatedWorkloadRepository(AWR)

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

点击查看答案
第7题
InanOracle10gdatabase,theinmemorystatisticsaregatheredatregularintervalsandusedtoperformgrowthtrendanalysisandcapacityplanningofthedatabase.Whichcomponentstoresthesestatistics?()

A.recoverycatalog

B.OracleEnterpriseManagerRepository

C.AutomaticWorkloadRepository(AWR)

D.Oracle10gEnterpriseManagerGridControl

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

点击查看答案
第8题
YouworkasadatabaseadministratorforCertkiller.com.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()

A.MemoryAdvisors

B.SegmentAdvisors

C.SQLTuningandAccessAdvisors

D.AutomatedWorkloadRepository(AWR)

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

点击查看答案
退出 登录/注册
发送账号至手机
密码将被重置
获取验证码
发送
温馨提示
该问题答案仅针对搜题卡用户开放,请点击购买搜题卡。
马上购买搜题卡
我已购买搜题卡, 登录账号 继续查看答案
重置密码
确认修改