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?
Which of the following is widely accepted as one of the critical components in networking management?
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 trans
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?
Which of the following types of firewalls provide the GREATEST degree and granularity of control?