单项选择题
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？（）
A. Set the CPU time per call in the users profile.
B. Set the CPU time per session in the users profile.
C. Set the CPU levels for the user’s group using Resource Manager.
D. Set the TIMED_STATISTICS parameter to TRUE in the parameter file. -
单项选择题
Youlosttheindextablespaceinyourdatabase.Youarenotabletousetablespacepoint-in-timerecoveryontheindextablespace.Whatcouldbethereasonforthis？（）
A. The index tablespace contains bitmap indexes.
B. The index tablespace contains more than one data file.
C. The index tablespace supports only complete recovery.
D. The index tablespace is not a dictionary-managed tablespace.
E. There is a dependency relationship between a table and its indexes. -
单项选择题
Youhaveadiskgroup，DGROUP1，withthreediskandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup：ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES（MIRRORFINE）；Whichstatementistrue？（）
A. When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B. When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C. When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D. When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E. When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.
