ExamCompetition Your Success, Our Mission
Login Register
Question discussion

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

358813Medium DSSSB TGT Computer Science 0 replies 0 views
0
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.
Correct answer: A

Explanation

WITH CHECK OPTION makes the DBMS check that every row inserted or updated through the view satisfies the view's WHERE condition.
Join the discussion Report an error

Discussion 0

Nobody has replied yet. Start the discussion!