edited by
1,287 views
0 votes
0 votes

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 :}$

  1. $\text{(a)-(iii); (b)-(iv); (c)-(i); (d)-(ii)}$
  2. $\text{(a)-(iv); (b)-(iii); (c)-(ii); (d)-(i)}$
  3. $\text{(a)-(iv); (b)-(ii); (c)-(iii); (d)-(i)}$
  4. $\text{(a)-(ii); (b)-(iii); (c)-(iv); (d)-(i)}$
edited by

2 Answers

0 votes
0 votes

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:

Related questions

0 votes
0 votes
2 answers
1
Arjun asked Nov 5, 2017
402 views
In SQL, ________ is an Aggregate function.SELECTCREATEAVGMODIFY
1 votes
1 votes
2 answers
2
Arjun asked Nov 5, 2017
3,072 views
Which speed up could be achieved according to Amdahl's Law for infinte number of processes if $5\%$ of a program is sequential and the remaining part is ideally parallel?...
0 votes
0 votes
1 answer
3
Arjun asked Nov 5, 2017
2,522 views
Which of the given wireless technologies used in IoT, consumes the least amount of power?ZigbeeBluetoothWi-FiGSM/CDMA
0 votes
0 votes
2 answers
4
Arjun asked Nov 5, 2017
4,593 views
Which of the following is not a Clustering method?K-Means methodSelf Organizing feature map methodK- nearest neighbor methodAgglomerative method