In SQL, what does the WITH CHECK OPTION clause do...
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state
TPSC Prelims previous year questions

In SQL, what does the WITH CHECK OPTION clause do in a view ?

Asked in TPSC Senior Technical Assistant 2026

  1. Prevents any data modification through the view completely
  2. Ensures inserted or updated rows satisfy the view condition
  3. Restricts the view to only display existing filtered records
  4. Automatically creates indexes to optimize view performance

Answer under review: our editors are checking this question. Try the other TPSC Prelims previous year questions questions meanwhile.

More TPSC Prelims previous year questions questions

All 772 TPSC Prelims previous year questions questions →