Question 9Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 2 (1:00 PM)

Which of the following statements about WITH CHECK OPTION in SQL views is true?

AIt ensures that inserted/updated rows satisfy the view’s WHERE clause.
BIt prevents any alter through the view.
CIt allows only ALTER operations on the view.
DIt makes the view read-only.

Show answerHide answer

Correct answer: (A) It ensures that inserted/updated rows satisfy the view’s WHERE clause.

Explanation

WITH CHECK OPTION rejects any INSERT or UPDATE through the view that would produce a row not satisfying the view's WHERE condition (a row that would vanish from the view).

Which of the following statements about WITH CHECK OPTION in SQL views is true?

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 2 (1:00 PM)