Topic: Database Management Systems
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
Answer: B. Views can be used to restrict access to sensitive columns
Explanation: A database view is a virtual table based on the result-set of a SQL statement. By creating a view that excludes sensitive columns (like passwords or salaries) and granting users access only to the view, an administrator can effectively restrict access to sensitive data.