Which two statements are true about dropping views? (Choose two.)

The correct answer is C. The creator of a view to be dropped must have the DROP ANY VIEW privilege. D. CASCADE CONSTRAINTS must be specified when referential integrity constraints on other. The view must be in your own schema or you must have the DROP ANY VIEW system privilege. Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the view to be dropped…

Creating Other Schema Objects

Question

Options

AData selected by a view's defining query is deleted from its underlying tables when the view is
BRead only views cannot be dropped.
CThe creator of a view to be dropped must have the DROP ANY VIEW privilege.
DCASCADE CONSTRAINTS must be specified when referential integrity constraints on other
EViews referencing a dropped view become invalid.

How the community answered

(20 responses)

A
5% (1)
B
15% (3)
C
70% (14)
E
10% (2)

Explanation

The view must be in your own schema or you must have the DROP ANY VIEW system privilege. Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the view to be dropped. https://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_9009.htm

Topics

#DROP VIEW#DROP ANY VIEW privilege#CASCADE CONSTRAINTS#view dependencies

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice