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

The WITH CHECK OPTION clause on a view ensures that any DML operation (INSERT/UPDATE) cannot create rows that the view’s defining query would exclude, protecting against modifications outside the sub‑query’s scope. The other keywords do not provide this restriction.

Keep practicing — related questions