Which of the following statement is true about database views?
2025
Which of the following statement is true about database views?
- A.
Views always store a duplicate copy of the data
- B.
Views can be used to restrict access to sensitive columns
- C.
Views cannot be queried like normal database tables
- D.
Views cannot be updated under any condition
Attempted by 82 students.
Show answer & explanation
Correct answer: B
Database views are virtual tables that do not store data physically, unlike materialized views. A key advantage of using views is security; they allow database administrators to restrict access by exposing only specific subsets of data, such as hiding sensitive columns. While views can be queried like regular tables, their update capabilities depend on the underlying query definition.