Oracle Database SQL — Question 113

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

Answer options

• A. The creator of a view to be dropped must have the DROP ANY VIEW privilege.
• B. Data selected by a view’s defining query is deleted from its underlying tables when the view is dropped.
• C. Views referencing a dropped view become invalid.
• D. Read only views cannot be dropped.
• E. CASCADE CONSTRAINTS must be specified when referential integrity constraints on other objects refer to primary or unique keys in the view to be dropped.

Correct answer: C, E

Explanation

The correct answers are C and E. When a view is dropped, any views that reference it become invalid, and if there are referential integrity constraints related to the view, CASCADE CONSTRAINTS must be specified to maintain integrity. Options A, B, and D are incorrect because they do not accurately describe the behavior of views when they are dropped.