Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 150

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

The creator of a view to be dropped must have the DROP ANY VIEW privilege.

Data selected by a view’s defining query is deleted from its underlying tables when the view is dropped.

Views referencing a dropped view become invalid.

Read only views cannot be dropped.

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: A, C

The creator of a view to be dropped must have the DROP ANY VIEW privilege, which ensures that only authorized users can drop views. Additionally, when a view is dropped, any other views that reference this view become invalid because their underlying structure has changed, leading to broken dependencies.

Discussion

Rik92Options: CE

checked. CE is correct

lucemqyOptions: CE

CE is the correct answer

Sathitest071Options: CE

Answer is CE https://www.examtopics.com/discussions/oracle/view/22610-exam-1z0-071-topic-2-question-68-discussion/