Intermediate
SQL
Q77 / 100
What does adding "WITH CHECK OPTION" to a view definition enforce?
Correct! Well done.
Incorrect.
The correct answer is B) It ensures that any INSERT or UPDATE performed through the view must satisfy the view's WHERE condition, rejecting rows that would not appear in the view
B
Correct Answer
It ensures that any INSERT or UPDATE performed through the view must satisfy the view's WHERE condition, rejecting rows that would not appear in the view
Explanation
WITH CHECK OPTION prevents modifications through an updatable view from creating rows that fall outside the view's defining WHERE clause.
Progress
77/100