YoucreatedtheDEPTtablebyusingthefollowingcommand:CREATETABLEscott.dept(deptnoNUMBER(3),dnameVARCHAR2(15),locVARCHAR2(15))STORAGE(INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4);YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshri

题目

YoucreatedtheDEPTtablebyusingthefollowingcommand:

CREATETABLEscott.dept

(deptnoNUMBER(3),

dnameVARCHAR2(15),

locVARCHAR2(15))

STORAGE(INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4);YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation,youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable?()


相似考题