单项选择题 YoucreatedtheDEPTtablebyusingthefollowingcommand：CREATETABLEscott.dept（deptnoNUMBER（3），dnameVARCHAR2（15），locVARCHAR2（15））STORAGE（INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4）；YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation，youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable？（）

单项选择题 Yourdatabaseisfunctionalwithpeakloadforonehour.Youwanttopreservetheperformancestatisticscollectedduringthisperiodsothattheycanbeusedforcomparisonwhileanalyzingtheperformanceofthedatabaseinthefuture.Whatactionwouldyoutaketoachievethistask？（）A.SettheSTATISTICS_LEVELinitializationparametertoALL.B.Createabaselineonapairofsnapshotsthathavethestatisticsofthepeak-loadperiodinthedatabase.C.DecreasethesnapshotintervalintheAWRtocollectmorenumberofsnapshotsduringthepeak-loadperiod.D.SetthesnapshotretentionperiodintheAutomaticWorkloadRepository（AWR）tozerotoavoidtheautomaticpurgingofthesnapshots.

单项选择题 YouaremaintainingyourOLTPdatabaseinOracle10g.Whileobservingtheperformanceofthedatabase，youfindthatthelogswitchoccursmorethanonceforevery20minutes，affectingthedatabaseperformance.Whichfactorisresponsibleforfrequentlogswitches？（）A.thevalueoftheUNDO_RETENTIONinitializationparameterB.thevalueoftheoptimalredologfilesizeprovidedbytheRedoLogfileSizeAdvisorC.theonlineredologfilessizeD.thenumberofredologmembersinagroup