Exam CISA Topic 3 Question 1142 Discussion

Actual exam question for ISACA's CISA exam
Question #: 1142
Topic #: 3
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:

Suggested Answer: A Vote an answer

Section: Protection of Information Assets
Explanation
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.

by Olive at Aug 04, 2025, 05:40 AM

Limited Time Offer

15%

Off

Get Premium CISA Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10