You are granted the CREATE VIEW privilege. What does this allow you to do?

The correct answer is C. Create a view in your schema. 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…

Controlling User Access

Question

Options

ACreate a table view.
BCreate a view in any schema.
CCreate a view in your schema.
DCreate a sequence view in any schema.
ECreate a view that is accessible by everyone.
FCreate a view only of it is based on tables that you created.

How the community answered

(40 responses)

A
3% (1)
B
10% (4)
C
83% (33)
E
5% (2)

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.

Topics

#CREATE VIEW privilege#system privileges#schema ownership#privilege scope

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice