Q: What is the purpose of enforcing constraints in a DBMS?

A To optimize query execution
B To ensure data consistency and integrity
C To improve database performance
D To provide data replication capabilities

Share this MCQ

Answer: B

Explanation:

Constraints in a DBMS are rules or conditions that are applied to the data to maintain its consistency and integrity.
They enforce data validation, relationships, and business rules, preventing the insertion of invalid or inconsistent data into the database.

Database Concepts MCQs

Share Above MCQ

‹ Previous Next ›

Write your comment

Learn More MCQ Questions from DataBase Management System Database Concepts MCQs

Q: What is the purpose of enforcing constraints in a DBMS?

Report Question