当前位置: Oracle DBA培训网-优技培训 >> ocp认证 > OCP认证教程 >

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

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

之前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/307596

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

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

技术沙龙MORE+

Oracle技术沙龙:【数据保护顶尖技术-MAA】首次全国首播12c MAA技术 云数据库加上MAA技术组成最豪华的技...
Oracle技术沙龙第49期:【Oracle 数据库云技术分享】Oracle技术沙龙第49期:【Oracle 数据库云技术分享】本次技术沙...
Oracle技术沙龙第48期:【Oracle 12c RAC安装】小编:今天讲什么内容呢?以后有什么用呢? 大师:今天讲的是12c...
我要参加技术沙龙