【OCP｜052】2018最新考试题库原题-10-cuug

《【OCP｜052】2018最新考试题库原题-10-cuug》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、cuug-052题库解析最新15道题www.cuug.com题库新特点：l最新052题库，按知识点分类，方便大家学习www.cuug.com⼗九.Privileges47.USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPto USER2.Sysexecutesthiscommand:SQL>REVOKEUPDATEONuser1.empFROMuser1;Whatwillbetheoutcome?A)ItwillfailbecauseUSER1istheown

2、erofUSER1.EMP. B)ItwillsucceedbutneitherUSER1norUSER2willbeabletoperform SELECT,INSERT,orUPDATEonUSER1.EMP.C)ItwillsucceedandonlyUSER1willbeunabletoperformSELECT, INSERT,orUPDATEonUSER1.EMP.D)ItwillsucceedandneitherUSER1norUSER2willbeabletoperform INSERTorUPDATEo

3、nUSER1.EMP,butbothwillbeabletoqueryUSER1.EMP. E)ItwillsucceedandonlyUSER2willbeunabletoperformSELECT, INSERT,orUPDATEonUSER1.EMP.Answer：Awww.cuug.com49.Examinethesefactsaboutadatabase:1.USERisthedatabasedefaulttablespace.2.USER1,USER2,andUSER3havetheCREATESESSION

4、privilege.3.TheyalsohaveUNLIMITEDQUOTAonthedefaulttablespaceUSERS.4.Theyhavenootherprivileges.Examinethesecommands:SQL>conn/assysdbaConnected.SQL>GRANTCREATETABLETOuser1WITHADMINOPTION;Grantsucceeded. SQL>connuser1/oracle_4UConnected.SQL>GRANTCREATETABLETOuser2;

5、Grantsucceeded.SQL>GRANTCREATETABLETOuser3WITHADMINOPTION; Grantsucceeded.www.cuug.comWhichtwoaretrue?A)IfSYSrevokesCREATETABLEfromUSER1,itisnotrevokedfrom USER2andUSER3.B)OnlySYScanrevokeCREATETABLEfromUSER1. C)IfSYSrevokesCREATETABLEfromUSER1,itisrevokedfromUSE

6、R2 butnotfromUSER3.D)AnyuserwithCREATETABLEWITHADMINOPTIONcanrevoke CREATETABLEfromUSER1.E)OnlySYSandUSER1canrevokeCREATETABLEfromUSER3.(为什么错了？）Answer：ADwww.cuug.com49.Inoneofyourdatabases:1.USER1andUSER2havenosystemprivileges. 2.ROLE1onlyhastheseprivileges: •CRE

7、ATESESSION•CREATETABLE•CREATEVIEWExaminethesecommands:SQL>conn/assysdbaConnected.SQL>GRANTcreatetable,role1TOuser1WITHADMINOPTION; Grantsucceeded.SQL>connuser1/oracle_4UConnected.SQL>GRANTrole1TOuser2;Grantsucceeded.Whichcommandwouldyouexecuteandaswhichuser,torev

8、okethecreatetable privilegefromUSER2?A)REVOKECREATETABLEFROMuser2asSYS B)REVOKECREATETABLEFROMrole1asSYS C)REVOKECREATETABLEFROMrole1asUSER1 www.cuug.comD)REVO