单项选择题
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 -
单项选择题
BtoB电子商务指的是().
A.商业机构对商业机构的电子商务是在企业和企业之间进行的
B.商业机构对消费者的电子商务是在企业与消费者之间进行的
C.商业机构对政府的电子商务是在企业与政府机构之间进行的
D.消费者对政府的电子商务是政府对个人的
