PrepAway - Latest Free Exam Questions & Answers

Which of the following will prevent dangling tuples in a database?

Which of the following will prevent dangling tuples in a database?

PrepAway - Latest Free Exam Questions & Answers

A.
Cyclic integrity

B.
Domain integrity

C.
Relational integrity

D.
Referential integrity

Explanation:

Referential integrity ensures that a foreign key in one table will equal null or the value of a primary
in the other table. For every tuple in a table having a referenced/foreign key, there should be a
corresponding tuple in another table, i.e., forexistence of all foreign keys in the original tables, if
this condition is not satisfied, then it results in a dangling tuple. Cyclical checking is the control
technique for the regular checking of accumulated data on a file against authorized
sourcedocumentation. There is no cyclical integrity testing. Domain integrity testing ensures that a
data item has a legitimate value in the correct range or set. Relational integrity is performed at the
record level and is ensured by calculating and verifying specific fields.


Leave a Reply