The objective of concurrency control in a database system is to:
The objective of concurrency control in a database system is to:
Which of the following controls would provide the GREATEST assurance of database integrity?
Which of the following controls would provide the GREATEST assurance of database integrity?
An IS auditor analyzing the audit log of a database management system (DBMS) finds that some transactions were
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?
During maintenance of a relational database, several values of the foreign key in a transaction table of a rel
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 dele
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.
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 den
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 independen
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 o
Which of the following database controls would ensure that the integrity of transactions is maintained in an online transaction processing systems database?
An IS auditor finds that, at certain times of the day, the data warehouse query performance decreases signific
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?