单项选择题

Examinethecommandsexecutedinthefollowingsequence：1：SQL>CREATEROLEmgrrole；2：SQL>GRANTcreateuser，selectanytable，connect，resourceTOmgrrole；3：SQL>GRANTselect，updateONsh.salesTOmgrrole；4：SQL>CREATEROLEceoIDENTIFIEDBYboss；5：SQL>GRANTmgrrole，dropanytable，createanydirectoryTOceo；6：SQL>GRANTceoTOmgrrole；Whichstatementistrueabouttheabovecommands（）
A.Thecommandsexecutesuccessfully.
B.Command6producesanerrorbecauseofcircularrolegrant.
C.Command5producesanerrorbecausearolecannotbegrantedtoanotherrole.
D.Command3producesanerrorbecausetheMGRROLErolealreadycontainssystemprivileges.
E.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.
F.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.

A.salesTOmgrrole；4：SQL>CREATEROLEceoIDENTIFIEDBYboss；5：SQL>GRANTmgrrole，dropanytable，createanydirectoryTOceo；6：SQL>GRANTceoTOmgrrole；Whichstatementistrueabouttheabovecommands（）
A.Thecommandsexecutesuccessfully.
B.Command6producesanerrorbecauseofcircularrolegrant.
C.Command5producesanerrorbecausearolecannotbegrantedtoanotherrole.
D.Command3producesanerrorbecausetheMGRROLErolealreadycontainssystemprivileges.
E.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.
F.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.

<上一题目录下一题>

热门试题

单项选择题

UserAexecutesthefollowingcommandtoupdatetheTRANStable）SQL>UPDATEB.transSETtr_amt=tr_amt+500WHEREc_code=’C005’；BeforeuserAissuesaCOMMITorROLLBACKcommand，userBexecutesthefollowingcommandontheTRANStable：SQl>ALTERTABLEtransMODIFY（tr_typeVARCHAR2（3））；Whatwouldhappeninthisscenario？（）A.ThetransactionforuserAisrolledback.B.TheALTERTABLEcommandmodifiesthecolumnsuccessfully.C.TheALTERTABLEcommandfailsduetotheresourcebeingbusy.D.TheALTERTABLEcommandwaitsuntiluserAendsthetransaction.

A.transSETtr_amt=tr_amt+500WHEREc_code=’C005’；BeforeuserAissuesaCOMMITorROLLBACKcommand，userBexecutesthefollowingcommandontheTRANStable：SQl>ALTERTABLEtransMODIFY（tr_typeVARCHAR2（3））；Whatwouldhappeninthisscenario？（）
A.ThetransactionforuserAisrolledback.
B.TheALTERTABLEcommandmodifiesthecolumnsuccessfully.
C.TheALTERTABLEcommandfailsduetotheresourcebeingbusy.
D.TheALTERTABLEcommandwaitsuntiluserAendsthetransaction.

单项选择题

At5：30PM，adatabaseadministrator，William，isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：SELECToperation，undo_sql，logon_userFROMFLASHBACK_TRANSACTION_QUERYWHERExid=HEXTORAW（’0100043E23456’）；where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）

A.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：