WorksheetsM4-Q3
Total questions: 10
Worksheet time: 10mins
The main focus of acceptance testing is
Ensuring that the system is acceptable to users
Ensuring that the system is acceptable to management
Accepting errors & bugs in the system
Ensuring that the system is acceptable to auditors
Which of the following test would be carried out when individual software modules are combined together as a group?
Unit testing
System testing
Integration testing
White box testing
Which of the following should be reviewed to provide assurance of the database referential integrity
Field definition
Foreign key structure
Master table definition
Composite keys
When evaluating the effectiveness and adequacy of a preventive computer maintenance program, which of the following would be considered to be MOST helpful to an IS Auditor?
A written preventive maintenance schedule
Regularly scheduled maintenance log
Vendors' reliability figures
A system downtime log
In a relational DBMS, a record refers to which of the following
Column
Tuple
Rows
Transaction
Which of the following will ensure that a column in one table will have a valid value or shall be “null” in another table’s column?
Primary key
Foreign key
Secondary key
SQL
Database normalization is
Data logging and accountability
Data redundancy optimization
Streamlining data process
Deleting temporary files
Which of the following is NOT a property of database transactions?
Durability
Consistency
Atomicity
Insulation
After discovering a security vulnerability in a third-party application that interfaces with several external systems, a patch is applied to a significant number of modules. Which of the following tests should an IS auditor recommend?
Stress
System
Black box
Interface
An organization has recently installed a security patch, which crashed the production server. To minimize the probability of this occurring again, an IS auditor should:
Apply the patch according to the patch's release notes.
Thoroughly test the patch before sending it to production.
Ensure that a good change management process is in place.
Approve the patch after doing a risk assessment.
