052认证考试新题库及答案整理-第27题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询之前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考试消息 + 学技术涨经验 + 过关考试 + 技术解答
Oracle金牌名师解析,直击考试要点
留言赠课:收看直播,赠送本次公开课解析视频及pdf考题,以及单次OCP课程,连续观看视频,累计送价值5000元的全套OCP视频课程!
更多OCP的052和053新题解析资料群:1015267481 验证码:OCP