Which constraint ensures that the data in a view cannot be changed?
A) WITH CHECK OPTION
B) WITH READ OPTION
C) WITH READ ONLY
D) NO WRITE OPTION

Question

Which constraint ensures that the data in a view cannot be changed?​
A) ​WITH CHECK OPTION
B) ​WITH READ OPTION
C) ​WITH READ ONLY
D) ​NO WRITE OPTION

Quizplus · Accepted Answer

The constraint that ensures that the data in a view cannot be changed is the “WITH READ ONLY” option. This restricts any modifications of data in the view and allows only SELECT operations. Option A (“WITH CHECK OPTION”) is used to limit updates and inserts to rows that satisfy a specified condition. Option B (“WITH READ OPTION”) is not a valid SQL constraint. Option D (“NO WRITE OPTION”) is not a valid SQL option.

Which Constraint Ensures That the Data in a View Cannot