Isaca CISA Quiz 206 Topic 6 Questions 1026-1030

Question: 1

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

Arestrict updating of the database to authorized users.

Bprevent integrity problems when two processes attempt to update the same data at the same time.

Cprevent inadvertent or unauthorized disclosure of data in the database.

Densure the accuracy, completeness and consistency of data.

Show Answer

Question: 2

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

AAudit log procedures

BTable link/reference checks

CQuery/table access time checks

DRollback androllforward database features

Show Answer

Question: 3

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?

AConsistency

BIsolation

CDurability

DAtomicity

Show Answer

Question: 4

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:

Athe detail of involved transactions may no longer be associated with master data, causing errors when these transactions are processed.

Bthere is no way of reconstructing the lost information, except by deleting the danglingtuples and reentering the transactions.

Cthe database will immediately stop execution and lose more information.

Dthe database will no longer accept input data.

Show Answer

Question: 5

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?

AForeign key

BPrimary key

CSecondary key

DPublic key

Show Answer

Isaca CISA Quiz:206 Topic:6 Questions:1026-1030