SQL Database Concepts Interview Question:

Tell me what do you understand by a view? What does the WITH CHECK OPTION clause for a view do?

Submitted by: Administrator

- A view is a virtual table that consists of fields from one or more real tables.
- It is usually used to join multiple tables and get the data.
- The WITH CHECK OPTION for a view prevents any modification to the data that does not confirm to the WHERE clause of the view definition.
- This allows the data belonging to the view to be updated through the view.
Submitted by: Administrator