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 database controls would ensure that the integrity of transactions is maintained in an
online transaction processing system’s database?

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?

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

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

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?

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:

An IS auditor analyzing the audit log of a database management system (DBMS) finds that some transactions
were partially executed as a result of an error, and are not rolled back. Which of the following transaction
processing features has been violated?

Which of the following controls would provide the GREATEST assurance of database integrity?

The objective of concurrency control in a database system is to: