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:

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
foreignkey.