Which of the following statement is CORRECT regarding Referential Integrity…

2023

Which of the following statement is CORRECT regarding Referential Integrity Constants in Relational Database Management System?

I. Referential Integrity Constants is a rule that maintains consistency among the rows of two tables (relations). II. Referential Integrity rule States that of there is a foreign key in one relation, either each foreign key value must match a primary key value in the other table or else the foreign key value must be null.

  1. A.

    Only II

  2. B.

    Both I and II

  3. C.

    Only I

  4. D.

    Neither I nor II

Attempted by 178 students.

Show answer & explanation

Correct answer: B

Referential integrity maintains consistency between related tables. A foreign key must either match a primary-key value in the referenced table or be null where allowed. Therefore, both statements are correct.

Explore the full course: Niacl Ao It Specialist