单项选择题

TheHRusercreatesaviewwiththiscommand：SQL>CREATEVIEWemp_vASSELECT*FROMscott.emp；NowHRwantstogranttheSELECTprivilegeontheEMP_VviewtotheJIMuser.Whichstatementistrueinthisscenario？（）

A.HRcangranttheprivilegetoJIMbutwithoutGRANTOPTION.
B.HRcangranttheprivilegetoJIMbecauseHRistheowneroftheview.
C.SCOTThastogranttheSELECTprivilegeontheEMPtabletoJIMbeforethisoperation.
D.HRneedstheSELECTprivilegeontheEMPtablewithGRANTOPTIONfromSCOTTforthisoperation.
<上一题 目录 下一题>
热门 试题

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