052认证考试新题库及答案整理-第27题

时间：2018-07-13 来源：

　　之前ocp认证考试的题库现在变了很多，比如051不再使用，052也换了很多新题，而且到现在还在不断的加入新考题，考试难度增加很大，这里整理了一些052的新题，希望对大家有帮助。

　　27、 Examine these facts about a database:

　　1. USERS 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_4U

　　Connected.

　　SQL> GRANT CREATE TABLE TO user2;

　　Grant succeeded.

　　SQL> GRANT CREATE TABLE TO user3 WITH ADMIN OPTION;

　　Grant succeeded.

　　12、 Which two are true?

　　A. Any user with create table with admin option can revoke create table from user1.

　　B. If SYS revokes create table from user1, it is revoked from user2 but not from user3.

　　C. Only SYS and USER1 can revoke CREATE TABLE from USER3.

　　D. Only SYS CAN REVOKE CREATE TABLE FROM USER1.

　　E. If SYS revokes create table from user1, it is not revoked from USER2 and USER3.

　　Answer: AE

　　新版OCP题库解析公开课地址：ke.qq.com/course/326223

　　收看直播 = 一手OCP考试消息 + 学技术涨经验 + 过关考试 + 技术解答

　　更多OCP的052和053新题解析资料群：569933648/836361015 验证码：ocp