UTpaper

Free mock tests & test series

Question 27Asked in UGC NET Computer Science, November 2017 (Paper II & III, Selected Questions)

Match the following with respect to RDBMS : A. Entity integrity

Match the following with respect to RDBMS : A. Entity integrity B. Domain integrity C. Referential integrity D. User defined integrity i. Enforces some specific business rule that to not fall into entity or domain ii. Rows can't be deleted which are used by other records iii. Enforces valid entries for a column iv. No duplicate rows in a table Code : A B C D
  1. Aiii iv i ii
  2. Biv iii ii i
  3. Civ ii iii i
  4. Dii iii iv i
Show answerHide answer

Correct answer: (B) iv iii ii i

Explanation

Entity integrity - no duplicate rows in a table (iv); Domain integrity - enforces valid entries for a column (iii); Referential integrity - rows can't be deleted which are used by other records (ii); User defined integrity - enforces specific business rules that do not fall into entity or domain integrity (i).

From UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions)

This is question 27 of UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions). 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.