Mark works as a Database Administrator for ExamTopics Inc.
The company has a SQL Server database.
Management instructs him to ensure that no inconsistent data is entered in the database.
Which of the following will help him to accomplish the task?
Mark works as a Database Administrator for ExamTopics Inc.
The company has a SQL Server database.
Management instructs him to ensure that no inconsistent data is entered in the database.
Which of the following will help him to accomplish the task?
Referential integrity is essential for ensuring that no inconsistent data is entered into the database. It enforces relationships between tables and ensures that all foreign key values actually correspond to primary key values, thereby maintaining data consistency.
A is correct
Referential integrity is a feature or property that prevents users or applications from entering inconsistent data which, when satisfied, requires every value of one column of a table to exist as a value of another column in a different or the same table