UTpaper

Free mock tests & test series

Question 179Asked in DSSSB TGT Computer Science, 7 Feb 2024, Shift 2 (12:30 PM)

In relational databases, which of the following integrity constraint is specified between

In relational databases, which of the following integrity constraint is specified between two relations and is used to maintain the consistency among tuples in the two relations?
  1. AEntity integrity constraint
  2. BSemantic integrity constraint
  3. CFunctional integrity constraint
  4. DReferential integrity constraint
Show answerHide answer

Correct answer: (D) Referential integrity constraint

Explanation

Referential integrity is specified between two relations: a foreign key value must match an existing primary key in the referenced relation, keeping tuples consistent.

From DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM)

This is question 179 of DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.