PrepAway - Latest Free Exam Questions & Answers

The consequence is that:

During maintenance of a relational database, several values of the foreign key in a transaction table of a
relational database have been corrupted. The consequence is that:

PrepAway - Latest Free Exam Questions & Answers

A.
the detail of involved transactions may no longer be associated with master data, causing errors when these
transactions are processed.

B.
there is no way of reconstructing the lost information, except by deleting the dangling tuples and reentering
the transactions.

C.
the database will immediately stop execution and lose more information.

D.
the database will no longer accept input data.

Explanation:
When the external key of a transaction is corrupted or lost, the application system will normally be incapable of
directly attaching the master data to the transaction data. This will normally cause the system to undertake a
sequential search and slow down the processing. If the concerned files are big, this slowdown will be
unacceptable. Choice B is incorrect, since a system can recover the corrupted external key by reindexing the
table. Choices C and D would not result from a corrupted foreign key.


Leave a Reply