Question 15328 – DSSSB PGT 2021
February 3, 2024Computer-Organization
February 3, 2024Relational-databases
|
Question 12
|
Match the following with respect to RDBMS :
|
(a)-(iii), (b)-(iv), (c)-(i), (d)-(ii)
|
|
|
(a)-(iv), (b)-(iii), (c)-(ii), (d)-(i)
|
|
|
(a)-(iv), (b)-(ii), (c)-(iii), (d)-(i)
|
|
|
(a)-(ii), (b)-(iii), (c)-(iv), (d)-(i)
|
Question 12 Explanation:
→ Entity Integrity won’t support duplicate rows in a table
→ Domain Integrity enforces valid entries for a column
→ Referential integrity rows can’t be deleted which are used by other records
→ User defined integrity enforces some specific business rule that do not fall into entity or domain
→ Domain Integrity enforces valid entries for a column
→ Referential integrity rows can’t be deleted which are used by other records
→ User defined integrity enforces some specific business rule that do not fall into entity or domain
Correct Answer: B
Question 12 Explanation:
→ Entity Integrity won’t support duplicate rows in a table
→ Domain Integrity enforces valid entries for a column
→ Referential integrity rows can’t be deleted which are used by other records
→ User defined integrity enforces some specific business rule that do not fall into entity or domain
→ Domain Integrity enforces valid entries for a column
→ Referential integrity rows can’t be deleted which are used by other records
→ User defined integrity enforces some specific business rule that do not fall into entity or domain