ViewtheExhibitandexaminetheuserinformation.TheuserhasbeengrantedCONNECTandRESOURCErolesandnoindividualsystemprivileges.TheSL_REPuserexecutesthiscommandtocreateatable:SQL>CREATETABLEorders(oidnumber(6),odatedate,ccodenumber(4),oamtnumber(10,2))TABLESPACEpu
题目
ViewtheExhibitandexaminetheuserinformation.TheuserhasbeengrantedCONNECTandRESOURCErolesandnoindividualsystemprivileges.TheSL_REPuserexecutesthiscommandtocreateatable:SQL>CREATETABLEorders(oidnumber(6),odatedate,ccodenumber(4),oamtnumber(10,2))TABLESPACEpurchase_space;ThePURCHASE_SPACEtablespacealreadyexistsinthedatabase.Whichstatementdescribestheeffectofthecommand（）
A.ThecommandexecutessuccessfullyandcreatesthetableintheUSERStablespace.
B.ThecommandexecutessuccessfullyandcreatesthetableinthePURCHASE_SPACEtablespace.
C.Thecommandproducesanerrorbecausetheuserdoesnothavetheprivilegetocreatethetable.
D.ThecommandproducesanerrorbecausetheuserdoesnothavequotainthePURCHASE_SPACEtablespace.
相似考题
参考答案和解析
参考答案：B