教学文章
Technology Exchange
Technology Exchange
热门课程
400电话
免费咨询热线
400-090-9964
11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。
对于这些052考试新题，不仅老师给出了答案，学员也积极的找资料、查文档，形成了一份内部综合版本，通过分数非常高，一起渡过这次052考试的难关。
-----------------------------------------------
052考试题-64（OCP考试题库讨论群：101-5267-481 验证：ocp）
Examine these facts about a database:
1.USERS is the database default tablespace.
2.USER1 and USER2 have the CREATE SESSION privilege.
3.They also have UNLIMITED QUOTA on the USERS tablespace.
Examine these commands:
SQL> conn / as sysdba
Connected.
SQL> GRANT CREATE TABLE TO USER1 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE VIEW TO USER1 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE MATERIALIZED VIEW TO USER1 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE MATERIALIZED VIEW TO USER2 WITH ADMIN OPTION;
Grant succeeded.
SQL> conn user1/oracle
Connected.
SQL> GRANT CREATE TABLE TO USER2 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE VIEW TO USER2 WITH ADMIN OPTION;
Grant succeeded.
SQL> conn / as sysdba
Connected.
SQL> REVOKE CREATE TABLE FROM USER1;
Revoke succeeded.
Which two are true?
A)USER1 cannot create tables but can create views and materialized views.
B)USER1 cannot create tables or materialized views, but can create views.
C)USER1 cannot create tables, views or materialized views.
D)USER2 cannot create tables but can create views and materialized views.
E)USER2 cannot create tables or materialized views, but can create views.
F)USER2 can create tables, views and materialized views.
Answer: BF
赵：已测试。AF=>BF。
B 对，USER1 一开始有创建表、视图、物化视图的权限，但后来创建表的权限被收回。而创建物化视图的前提是必须有创建表的权限，所以在表权限收回后也不能再创建物化视图了。
F 对，USER2 被 SYS 和 USER1 分别授予了创建表、视图和物化视图的权限。
CREATE MATERIALIZED VIEW
Prerequisites
The privileges required to create a materialized view should be granted directly rather than through a role.
To create a materialized view in your own schema:
You must have been granted the CREATE MATERIALIZED VIEW system privilege and either the CREATE TABLE or CREATE ANY TABLE system privilege.
You must also have access to any master tables of the materialized view that you do not own, either through a SELECT object privilege on each of the tables or through the SELECT ANY TABLE system privilege.
To create a materialized view in another user's schema:
...