CUUG内部OCP题库解析-052-文档10
28页1、CUUG内部OCP题库解析-052-文档10题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。下面的题是(052考试-第10个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档10 7/17/19九.Privileges47. USER1 grants SELECT, INSERT, and UPDATE privileges on USER1.EMP to USER2. Sys executes this command:SQL REVOKE UPDATE ON user1.emp FROM user1; What will be the outcome?A) It will fail because USER1 is the owner of USER1.EMP.B) It will succeed but neither USER1 nor USER2 will be able to perform
2、SELECT, INSERT, or UPDATEon USER1.EMP.C) It will succeed and only USER1 will be unable to perform SELECT,INSERT, or UPDATE onUSER1.EMP.D) It will succeed and neither USER1 nor USER2 will be able to performINSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP.E) It will succeed and only USER2 will be unable to perform SELECT,INSERT, or UPDATE onUSER1.EMP. Answer:A49. Examine these facts about a database: 1. USER is the database default tablespace.2. USER1, USER2, and USER3 have
3、the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the default tablespace USERS.4. They have no other privileges.Examine these commands:SQL conn / as sysdba Connected.SQL GRANT CREATE TABLE TO user1 WITH ADMIN OPTION; Grant succeeded.SQL conn user1/oracle_4UConnected.SQL GRANT CREATE TABLE TO user2;Grant succeeded.SQL GRANT CREATE TABLE TO user3 WITH ADMIN OPTION;Grant succeeded.Which two are true?A) If SYS revokes CREATE TABLE from USER1, it is not revoked fromUSER2 and USER3.B)
4、Only SYS can revoke CREATE TABLE from USER1.C) If SYS revokes CREATE TABLE from USER1, it is revoked from USER2but not from USER3.D) Any user with CREATE TABLE WITH ADMIN OPTION can revokeCREATE TABLE from USER1.E) Only SYS and USER1 can revoke CREATE TABLE from USER3.(为什么错 了?)Answer: AD49. In one of your databases:1. USER1 and USER2 have no system privileges. 2. ROLE1 only has these privileges: CREATE SESSION CREATE TABLE CREATE VIEWExamine these commands: SQL conn / as sysdbaConnected.SQL GRAN
《CUUG内部OCP题库解析-052-文档10》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-052-文档10》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页