CUUG内部OCP题库解析-052-文档10

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 performSELECT, 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 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) 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> GRANT create table, role1 TO user1 WITH ADMIN OPTION;Grant succeeded.SQL> conn user1/oracle_4U Connected.SQL> GRANT role1 TO user2; Grant succeeded.Which command would you execute and as which user, to revoke the create tableprivilege from USER2? A) REVOKE CREATE TABLE FROM user2 as SYSB) REVOKE CREATE TABLE FROM role1 as SYSC) REVOKE CREATE TABLE FROM role1 as USER1D) REVOKE CREATE TABLE FROM user1 as SYSAnswer: B只有sys用户才能够从role中revoke权限，而user1只能把role授权给其它用户，或者从其它用户回 收role。51. Examine these facts about a database: The database default tablespace to EXAMPLE. DEFERRED_SEGMENT_CREATION is TRUE （原来为FALSE，题目有错） Examine these commands: SQL> CREATE USER user1 IDENTIFIED BY oracle_4U PASSWORD EXPIRE; User created.SQL>ALTER USER user1 IDENTIFIED BY oracle;User altered.SQL>GRANT CREATE SESSION TO user1;Grant succeeded.SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION; Grant succeeded.Which four are true?A) User1 can connect to the database instance. B) User1 can create in the EXAMPLE tablespace. C) User1 must change the password at rst login. D) User1 can grant the CREATE SESSION privilege to other users.E) User1 can grant the CREATE TABLE privilege to other users.F) User1 can REVOKE the CREATE TABLE privilege from users that were granted theprivilege by SYS .G) User1 can REVOKE the CREATE SESSION privilege from users that were granted the privilege by SYS .Answer: ABEF52. IN one of your databases;The database default tablespace is EXAMPLE.DEFERRED_SEGMENT_CREATION IS FALES.Examine these commands;SQL.>CREATE USER user1 IDENTIFIED BY oracle_4Upassword expire; User created.SQL>ALTER USER user1 ACCOUUNT UNLOCK;User altered.SQL>GRANT CREATE SEAAION TO user1;Grant succeeded;SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;Grant succeeded.Which three are true?A) USER1 can create indexes in EXAMPLE tablespaceB) USER1 can grant the CREATE TABLE privilege to other usersC) USER1 can log into the database instanceD) USER1 must change its password at rst loginE) USER1 can create tables in the EXAMPLE tablespace Answer：BCD53. IN one of your databases; The database default tablespace is EXAMPLE. DEFERRED_SEGMENT_CREATION IS FALSE.Examine these commands;SQL> CREATE USER user1 IDENTIFIED BY oracle_4U; Usercreated.SQL>GRANT CREATE SESSION TO user1;User alteredWhich two are true?A) USER1 can create tables in EXAMPLE tablespaceB) USER1 must change their password at rst loginC) USER1 can create tables in the EXAMPLE tablespaceD) USER1 can be granted access to tables in other schemasE) USER1 can log in to the database instance.Answer：DE 54. You have decided to implement the principle of least privilege andseparation of duties. Which two actions must you take?A) Grant SYSOPER to application schema owners.B) Grant access to the Oracle software owner O/S account to all dat