Database Fundamentals — Question 100

A view can be used to:

Answer options

• A. Save an extra copy of data stored in a separate table.
• B. Limit access to specific rows or columns of data in a table.
• C. Ensure referential integrity.
• D. Save historical data before deleting it from the base table.

Correct answer: B

Explanation

The correct answer is B because views can be designed to expose only certain rows or columns of a table, providing a layer of security. Options A, C, and D are incorrect as views do not physically store data, do not ensure referential integrity, and do not function as a means to save historical data.