Database Fundamentals — Question 105

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?

Answer options

• A. Referential integrity
• B. Abstraction
• C. Encryption
• D. Authentication
• E. Native auditing

Correct answer: A

Explanation

Referential integrity is crucial for ensuring that relationships between tables remain consistent, thus preventing the entry of invalid data. The other options, such as abstraction, encryption, authentication, and native auditing, serve different purposes, such as securing data or managing user access, but they do not specifically address the issue of maintaining data consistency.