单项选择题
Youdiscoveranout-of-spaceconditioninthedatabase.Youdecidetosuspendasessionforfiveminutes.Youissuethefollowingcommandtosuspendthesession：ALTERSESSIONENABLERESUMABLE；Whichcommandcouldyouissuetoenabletheresumablespaceallocationfeatureatthesessionlevel？（）
A.ALTERSESSIONENABLERESUMABLE_TIMEOUT=5；
B.ALTERSYSTEMENABLERESUMABLE_TIMEOUT=5；
C.ALTERSESSIONENABLERESUMABLE_TIMEOUT=300；
D.ALTERSYSTEMENABLERESUMABLETIMEOUT=300；
- A.Youdecidetosuspendasessionforfiveminutes.Youissuethefollowingcommandtosuspendthesession：ALTERSESSIONENABLERESUMABLE；Whichcommandcouldyouissuetoenabletheresumablespaceallocationfeatureatthesessionlevel？（）
A.ALTERSESSIONENABLERESUMABLE_TIMEOUT=5；
B.ALTERSYSTEMENABLERESUMABLE_TIMEOUT=5；
C.ALTERSESSIONENABLERESUMABLE_TIMEOUT=300；
D.ALTERSYSTEMENABLERESUMABLETIMEOUT=300；
相关考题
-
单项选择题
YoucreatedtheDEPTtablebyusingthefollowingcommand：CREATETABLEscott.dept（deptnoNUMBER（3），dnameVARCHAR2（15），locVARCHAR2（15））STORAGE（INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4）；YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation，youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable？（）
A.dept
-
单项选择题
Yourdatabaseisfunctionalwithpeakloadforonehour.Youwanttopreservetheperformancestatisticscollectedduringthisperiodsothattheycanbeusedforcomparisonwhileanalyzingtheperformanceofthedatabaseinthefuture.Whatactionwouldyoutaketoachievethistask？（）A.SettheSTATISTICS_LEVELinitializationparametertoALL.B.Createabaselineonapairofsnapshotsthathavethestatisticsofthepeak-loadperiodinthedatabase.C.DecreasethesnapshotintervalintheAWRtocollectmorenumberofsnapshotsduringthepeak-loadperiod.D.SetthesnapshotretentionperiodintheAutomaticWorkloadRepository（AWR）tozerotoavoidtheautomaticpurgingofthesnapshots.
A.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
A.Whileobservingtheperformanceofthedatabase，youfindthatthelogswitchoccursmorethanonceforevery20minutes，affectingthedatabaseperformance.Whichfactorisresponsibleforfrequentlogswitches？（）
A.thevalueoftheUNDO_RETENTIONinitializationparameter
B.thevalueoftheoptimalredologfilesizeprovidedbytheRedoLogfileSizeAdvisor
C.theonlineredologfilessize
D.thenumberofredologmembersinagroup
