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:

In a relational database with referential integrity, the use of which of the following keys would
prevent deletion of a row from a customer table as long as the customer number of that row is
stored with live orders on the orders table?

When performing a database review, an IS auditor notices that some tables in the database are
not normalized. The IS auditor should next:

A database administrator has detected a performance problem with some tables which
could be solved through denormalization. This situation will increase the risk of:

An IS auditor finds that client requests were processed multiple times when received
from different independent departmental databases, which are synchronized weekly. What would
be the BEST recommendation?

Which of the following database controls would ensure that the integrity of transactions
is maintained in an online transaction processing system’s database?

An IS auditor finds that, at certain times of the day, the data warehouse query
performance decreases significantly. Which of the following controls would it be relevant for the IS
auditor to review?

Which of the following is widely accepted as one of the critical components in networking
management?

Which of the following controls will MOST effectively detect the presence of bursts of errors in
network transmissions?

Which of the following types of firewalls provide the GREATEST degree and granularity of control?