You are granted the CREATE VIEW privilege. What does this allow you to do?
A.
Create a table view.
B.
Create a view in any schema.
C.
Create a view in your schema.
D.
Create a sequence view in any schema.
E.
Create a view that is accessible by everyone.
F.
Create a view only of it is based on tables that you created.
Explanation:
You can create a view in your own schema only if you are granted the CREATE VIEW privilege.
Incorrect Answers
A:. You can create a view in your own schema only.
B:. You can create a view in your own schema only, not in any schema.
D:. There is no sequence view in Oracle.
E:. You cannot create a view that is accessible by everyone. You will need specially grant SELECT privileges on
this view for everyone.
F:. You can create a view in your own schema, but not only for tables in your schema. You can use object from
other users schemas if you have privileges to retrieve data from them.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 292-301
Chapter 7: Creating Other Database Objects in Oracle
https://docs.oracle.com/cd/B10501_01/server.920/a96524/c24privs.htm
You must have been granted one of the following system privileges, either explicitly or through a role:
The CREATE VIEW system privilege (to create a view in your schema)
The CREATE ANY VIEW system privilege (to create a view in another user’s schema)