单项选择题
单项选择题 YoumovedtheindexEMP_NO_INDXfromonetablespacetoanotherandthenissuedthefollowingcommandtorebuildtheindexEMP_NO_INDX:SQL>ALTERINDEXEMP_NO_INDXREBUILDONLINE;WhichtableallowstheuserstoaccesstheEMP_NO_INDXindexwhileperformingtherebuildoperation?()A.Index-organizedtableB.MappingTableC.ClusteredTableD.JournalTable
单项选择题 Youdiscoveranout-of-spaceconditioninthedatabase.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?()