单项选择题

YoumovedtheindexEMP_NO_INDXfromonetablespacetoanotherandthenissuedthefollowingcommandtorebuildtheindexEMP_NO_INDX：SQL>ALTERINDEXEMP_NO_INDXREBUILDONLINE；WhichtableallowstheuserstoaccesstheEMP_NO_INDXindexwhileperformingtherebuildoperation？（）
A.Index-organizedtable
B.MappingTable
C.ClusteredTable
D.JournalTable

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题
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.