UGC NET November 2017 cs question paper solution set II Q18

Question 18

---

Match the following with respect to RDBMS:

(a) Entity integrity	(i) enforces some specific business rule that do not fall  into entity or domain
(b) Domain integrity	(ii) Rows can’t be deleted which are used by other records
(c) Referential integrity	(iii) enforces valid entries for a column
(d) Userdefined integrity	(iv) No duplicate rows in a table

Code :

	(a)	(b)	(c)	(d)
(1)	(iii)	(iv)	(i)	(ii)
(2)	(iv)	(iii)	(ii)	(i)
(3)	(iv)	(ii)	(iii)	(i)
(4)	(ii)	(iii)	(iv)	(i)

Answer: 2

Explanation:

Entity integrity is defined by using primary key of table. it defines that table should not allow duplicate rows in table. Each row in the Table is identified by unique and non-null key called primary key.
Here option (a) match with (iv)  > ( a - iv )

Domain integrity specifies that all columns in a relational database must be declared based on a defined domain (Here domain means type of the column, it can be Integer, Varchar, Long, . etc).
If some table column has data type of integer then it will not allow any string values. That means this column value includes only Integer domain values.
Here option (b) match with (iii)  > ( b - iii )

Referential integrity implies that rows can't be deleted in master table if that are in use or referred by some other table.
Here option (c) match with (ii)  > (c-ii)

So, Correct answer should be option 2.