UGC NET CSE | November 2017 | Part 2 | Question: 18

Question

Match the following with respect to RDBMS :

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

$\textbf{Code :}$

• A. $\text{(a)-(iii); (b)-(iv); (c)-(i); (d)-(ii)}$
• B. $\text{(a)-(iv); (b)-(iii); (c)-(ii); (d)-(i)}$
• C. $\text{(a)-(iv); (b)-(ii); (c)-(iii); (d)-(i)}$
• D. $\text{(a)-(ii); (b)-(iii); (c)-(iv); (d)-(i)}$

Answer 1

Entity integrity is used to provide primary key mechanism hence there should be no duplicate rows in table. (a-iv)

Domain integrity specifies that all columns in a relational database must be declared upon a defined domain .(b -iii)

Referential integrity means we cannot delete records in master table before deleting the records from the child table. (c-ii)

Answer should be option 2.

Answer 2

a)-- iv

b)--iii

c)--ii

d)--i

Option B is correct

Answer 3

(B) is the correct Option Because....

(A) Entity Integrity inforces to have primary key cant have null value from  which can say that (iv) No duplicate row in a table

(B) Domain Integrity   it enforce  (iii) valid entries for a coulumn.

(C) Referential integrity it say that a foreign key refers to a primary key and (ii)  primary key  row which uses by the foreign key can't be deleted..

(D) User defined integrity -- (i) It enforces some rule by the author itself..

 

Thanks!!