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:

Which of the following will prevent dangling tuples in a database?