Database Fundamentals — Question 19

This question requires that you evaluate the underlined text to determine if it is correct.
A view can be used to ensure referential integrity.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Answer options

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

Correct answer: C

Explanation

The correct answer is C because limiting access to specific rows or columns of data can help manage data integrity and security in a relational database. Options A, B, and D do not directly relate to maintaining referential integrity as they focus on data storage and access rather than ensuring relationships between tables.