Question 1

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

Accepted Answer

A) True 
 B)False

Question 2

The database management system controls access to program files.

Accepted Answer

A) True 
 B)False

Question 3

Audit objectives for the database management system include all of the following except

Accepted Answer

A)  verifying that the security group monitors and reports on fault tolerance violations 
B)  confirming that backup procedures are adequate 
C)  ensuring that authorized users access only those files they need to perform their duties 
D)  verifying that unauthorized users cannot access data files 
A)  verifying that the security group monitors and reports on fault tolerance violations 
B)  confirming that backup procedures are adequate 
C)  ensuring that authorized users access only those files they need to perform their duties 
D)  verifying that unauthorized users cannot access data files

Question 4

Which of the following is not a common form of conceptual database model?

Accepted Answer

A)  hierarchical 
B)  network 
C)  sequential 
D)  relational 
A)  hierarchical 
B)  network 
C)  sequential 
D)  relational

Question 5

The data definition language is used to insert special database commands into application programs.

Accepted Answer

A) True 
 B)False

Question 6

What is a database lockout?

Accepted Answer

To achieve data currency,simultaneous ac

Question 7

What flat-file data management problems are solved as a result of using the database concept?

Accepted Answer

a.no data redundancy
b.single

Question 8

A customer name and an unpaid balance is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following may provide many distinct views of the database?

Accepted Answer

A)  the schema 
B)  the internal view 
C)  the user view 
D)  the conceptual view 
A)  the schema 
B)  the internal view 
C)  the user view 
D)  the conceptual view

Question 10

The advantages of a partitioned database include all of the following except

Accepted Answer

A)  user control is enhanced 
B)  data transmission volume is increased 
C)  response time is improved 
D)  risk of destruction of entire database is reduced 
A)  user control is enhanced 
B)  data transmission volume is increased 
C)  response time is improved 
D)  risk of destruction of entire database is reduced

Question 11

Use the following words to complete the sentences in questions 1 through 5.
  
-The conceptual view of the database is often called ____________________.

Accepted Answer

The answer of Use the following words to complete the...

Question 12

What is the internal view of a database?

Accepted Answer

The internal view of a databas

Question 13

Subschemas are used to authorize user access privileges to specific data elements.

Accepted Answer

A) True 
 B)False

Question 14

What are four ways in which database management systems provide a controlled environment to manage user access and the data resources?

Accepted Answer

Program development,

Question 15

Data currency is preserved in a centralized database by

Accepted Answer

A)  partitioning the database 
B)  using a lockout procedure 
C)  replicating the database 
D)  implementing concurrency controls 
A)  partitioning the database 
B)  using a lockout procedure 
C)  replicating the database 
D)  implementing concurrency controls

Question 16

What are two types of distributed databases?

Accepted Answer

Partitione

Question 17

A deadlock is a phenomenon that prevents the processing of transactions.

Accepted Answer

A) True 
 B)False

Question 18

When creating and controlling backups for a sequential batch system,

Accepted Answer

A)  the number of backup versions retained depends on the amount of data in the file 
B)  off-site backups are not required 
C)  backup files can never be used for scratch files 
D)  the more significant the data, the greater the number of backup versions 
A)  the number of backup versions retained depends on the amount of data in the file 
B)  off-site backups are not required 
C)  backup files can never be used for scratch files 
D)  the more significant the data, the greater the number of backup versions

Question 19

The database approach to data management is sometimes called the flat file approach.

Accepted Answer

A) True 
 B)False

Question 20

What is a replicated database and what are the advantages of this approach?

Accepted Answer

The entire database is replicated at eac

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

The database management system controls access to program files.

Audit objectives for the database management system include all of the following except

Which of the following is not a common form of conceptual database model?

The data definition language is used to insert special database commands into application programs.

What is a database lockout?

What flat-file data management problems are solved as a result of using the database concept?

A customer name and an unpaid balance is an example of a one-to-many relationship.

Which of the following may provide many distinct views of the database?

The advantages of a partitioned database include all of the following except

Use the following words to complete the sentences in questions 1 through 5. -The conceptual view of the database is often called ____________________.

What is the internal view of a database?

Subschemas are used to authorize user access privileges to specific data elements.

What are four ways in which database management systems provide a controlled environment to manage user access and the data resources?

Data currency is preserved in a centralized database by

What are two types of distributed databases?

A deadlock is a phenomenon that prevents the processing of transactions.

When creating and controlling backups for a sequential batch system,

The database approach to data management is sometimes called the flat file approach.

What is a replicated database and what are the advantages of this approach?

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Data Structures and CAATTs for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Enterprise Resource Planning Systems

Filters

Exam 4: IT Security Part II: Auditing Database Systems

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

The database management system controls access to program files.

Audit objectives for the database management system include all of the following except

Which of the following is not a common form of conceptual database model?

The data definition language is used to insert special database commands into application programs.

What is a database lockout?

What flat-file data management problems are solved as a result of using the database concept?

A customer name and an unpaid balance is an example of a one-to-many relationship.

Which of the following may provide many distinct views of the database?

The advantages of a partitioned database include all of the following except

Use the following words to complete the sentences in questions 1 through 5. -The conceptual view of the database is often called ____________________.

What is the internal view of a database?

Subschemas are used to authorize user access privileges to specific data elements.

What are four ways in which database management systems provide a controlled environment to manage user access and the data resources?

Data currency is preserved in a centralized database by

What are two types of distributed databases?

A deadlock is a phenomenon that prevents the processing of transactions.

When creating and controlling backups for a sequential batch system,

The database approach to data management is sometimes called the flat file approach.

What is a replicated database and what are the advantages of this approach?

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Data Structures and CAATTs for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Enterprise Resource Planning Systems

Filters