black

1z0-043

单项选择题

Exhibit： View the Exhibit and examine the characteristic 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？（）

A. Memory Advisor
B. Segment Advisor
C. SLQ Tuning Advisor
D. SLQ Access Advisor
E. Automatic Database Diagnostic Monitor （ADDM）

相关考题

单项选择题 FortheV$SESSION_LONGOPSview，youfindthatsomeofthedatabaseusershavelong-runningqueriesthatconsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase，whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime，butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis？（）

单项选择题 Youlosttheindextablespaceinyourdatabase.Youarenotabletousetablespacepoint-in-timerecoveryontheindextablespace.Whatcouldbethereasonforthis？（）

单项选择题 Youhaveadiskgroup，DGROUP1，withthreediskandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup：ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES（MIRRORFINE）；Whichstatementistrue？（）

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

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064