网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

TheuserHRownstheEMPtable.TheuserHRgrantsprivilegestotheuserSCOTTbyusingthiscommand:SQL>GRANTSELECT,INSERT,UPDATEONempTOscottWITHGRANTOPTION;TheuserSCOTTexecutesthiscommandtograntprivilegestotheuserJIM:SQL>GRANTSELECT,INSERT,UPDATEONhr.empTOjim;Now,theuserHRdecidestorevokeprivilegesfromJIMusingthiscommand:SQL>REVOKESELECT,INSERT,UPDATEONempFROMjim;WhichstatementistrueafterHRissuestheREVOKEcommand()

A.ThecommandfailsbecauseSCOTTstillhasprivileges.

B.ThecommandsucceedsandprivilegesarerevokedfromJIM.

C.ThecommandfailsbecauseHRcannotrevoketheprivilegesfromJIM.

D.ThecommandsucceedsandonlyHRhastheprivilegetoperformtheSELECT,INSERT,andUPDATEoperationsontheEMPtable.


参考答案

更多 “ TheuserHRownstheEMPtable.TheuserHRgrantsprivilegestotheuserSCOTTbyusingthiscommand:SQLGRANTSELECT,INSERT,UPDATEONempTOscottWITHGRANTOPTION;TheuserSCOTTexecutesthiscommandtograntprivilegestotheuserJIM:SQLGRANTSELECT,INSERT,UPDATEONhr.empTOjim;Now,theuserHRdecidestorevokeprivilegesfromJIMusingthiscommand:SQLREVOKESELECT,INSERT,UPDATEONempFROMjim;WhichstatementistrueafterHRissuestheREVOKEcommand()A.ThecommandfailsbecauseSCOTTstillhasprivileges.B.ThecommandsucceedsandprivilegesarerevokedfromJIM.C.ThecommandfailsbecauseHRcannotrevoketheprivilegesfromJIM.D.ThecommandsucceedsandonlyHRhastheprivilegetoperformtheSELECT,INSERT,andUPDATEoperationsontheEMPtable. ” 相关考题