quiz

Integrity Constraints in DBMS

1. What is the primary purpose of integrity constraints in DBMS?

  • A) To define relationships between tables
  • B) To enforce security measures on database access
  • C) To maintain the consistency and accuracy of data
  • D) To optimize query performance
C) To maintain the consistency and accuracy of data Explanation

2. Which integrity constraint ensures that a primary key cannot have a null value in a relational table?

  • A) Referential Integrity Constraint
  • B) Entity Integrity Constraint
  • C) Domain Constraint
  • D) Key Constraint
B) Entity Integrity Constraint Explanation

3. What does a domain constraint specify in a database?

  • A) A valid set of values for an attribute
  • B) Constraints on foreign keys
  • C) Relationships between tables
  • D) Unique keys in a table
A) A Valid set of values for an attribute Explanation

4. Which of the following constraints enforces Referential Integrity in a database?

  • A) Primary Key Constraint
  • B) Unique Constraint
  • C) Foreign Key Constraint
  • D) Check Constraint
C) Foreign Key Constraint Explanation

Quick Links