Multiple choice technology databases

Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?

  1. CHECK keyword

  2. WITH CHECK keyword

  3. WITH CHECK OPTION keyword

  4. None of the Above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

WITH CHECK OPTION is a clause used with updatable views that prevents INSERT or UPDATE operations on rows that would not be visible through the view. It ensures that DML operations only affect rows that satisfy the subquery defining the view.

Keep practicing — related questions