UTpaper

Free mock tests & test series

Question 50

Consider the database table "Persons" having persons_ID as the primary key:

Consider the database table "Persons" having persons_ID as the primary key: person_ID | Name | Age 1000 | Rajan | 40 - | Jatin | -45 1001 | Rajesh | 35 What are the constraints violated by the above table ?
  1. ARelationship integrity
  2. BReferential integrity only
  3. CEntity and domain integrities
  4. DReferential and domain integrities
Show answerHide answer

Correct answer: (C) Entity and domain integrities

Explanation

A missing person_ID breaks entity integrity, because a primary key cannot be null. An age of −45 is outside the valid domain, so domain integrity is also broken.

From DSSSB TGT Computer Science Practice Set 1

This is question 50 of DSSSB TGT Computer Science Practice Set 1. 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.