• 搜标题
  • 搜题干
  • 搜选项
0 / 200字
单项选择题

YoucreateanewAutomaticDatabaseDiagnosticMonitor（ADDM）task：instance_analysis_mode_task.ToviewtheADDMreport，youusethefollowingcommand：SQL>SELECTdbms_addm.get_report（’my_instance_analysis_mode_task’）FROMdual；YouwanttosuppressADDMoutputrelatingtoSegmentAdvisoractionsonuserSCOTT’ssegments.Whatwouldyoudotoachievethis？（）
A.AddafindingdirectivefortheADDMtask.
B.AddasegmentdirectivefortheADDMtask.
C.AddaparameterdirectivefortheADDMtask.
D.DisabletheSegmentAdvisorfromtheAutomaticMaintenanceTask.

A.ToviewtheADDMreport，youusethefollowingcommand：SQL>SELECTdbms_addm.get_report（’my_instance_analysis_mode_task’）FROMdual；YouwanttosuppressADDMoutputrelatingtoSegmentAdvisoractionsonuserSCOTT’ssegments.Whatwouldyoudotoachievethis？（）
A.AddafindingdirectivefortheADDMtask.
B.AddasegmentdirectivefortheADDMtask.
C.AddaparameterdirectivefortheADDMtask.
D.DisabletheSegmentAdvisorfromtheAutomaticMaintenanceTask.
题目列表

你可能感兴趣的试题

单项选择题

Coherenceprovidestheidealinfrastructureforbuilding_____services，andthe______applications.（）

A.DataGrid；ClientandServerbased
B.Outster；ClientandServerbased
C.DataGrid；DNSbased
D.Cloudcluster；ClientandServerbased
单项选择题

Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache：SQL>ALTERSYSTEMSETDB_CACHE_SIZE=2516582；Systemaltered.Toverifythechangeinsize，youexecutedthiscommand：SQL>SHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304（4M）Whyisthevaluesetto4194304andnotto2516582（）
A.because4194304isthegranulesize
B.because4194304isthestandardblocksize
C.because4194304isthelargestnonstandardblocksizedefinedinthedatabase
D.because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache

A.Toverifythechangeinsize，youexecutedthiscommand：SQL>SHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304（4M）Whyisthevaluesetto4194304andnotto2516582（）
A.because4194304isthegranulesize
B.because4194304isthestandardblocksize
C.because4194304isthelargestnonstandardblocksizedefinedinthedatabase
D.because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache
微信扫码免费搜题