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