Question 1

What is a data dictionary, and what purpose does it serve?

Accepted Answer

The data dictionary describes every data

Question 2

Users access the database

Accepted Answer

A)  by direct query 
B)  by developing operating software 
C)  by constantly interacting with systems programmers 
D)  all of the above 
A)  by direct query 
B)  by developing operating software 
C)  by constantly interacting with systems programmers 
D)  all of the above

Question 3

Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations.

Accepted Answer

A one-to-one association means that for

Question 4

In a distributed data processing system, a database can be centralized or distributed. What are the options? Explain.

Accepted Answer

In a distributed data processing system,

Question 5

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

Accepted Answer

The entire database is replicated at eac

Question 6

Which of the following is not a responsibility of the database management system?

Accepted Answer

A)  provide an interface between the users and the physical database 
B)  provide security against a natural disaster 
C)  ensure that the internal schema and external schema are consistent 
D)  authorize access to portions of the database 
A)  provide an interface between the users and the physical database 
B)  provide security against a natural disaster 
C)  ensure that the internal schema and external schema are consistent 
D)  authorize access to portions of the database

Question 7

Which term is not associated with the relational database model?

Accepted Answer

A)  tuple 
B)  attribute 
C)  collision 
D)  relation 
A)  tuple 
B)  attribute 
C)  collision 
D)  relation

Question 8

All of the following are basic data management tasks except

Accepted Answer

A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval 
A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval

Question 9

The data definition language

Accepted Answer

A)  identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database 
A)  identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database

Question 10

The task of searching the database to locate a stored record for processing is called

Accepted Answer

A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval 
A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval

Question 11

Which characteristic is associated with the database approach to data management?

Accepted Answer

A)  data sharing 
B)  multiple storage procedures 
C)  data redundancy 
D)  excessive storage costs 
A)  data sharing 
B)  multiple storage procedures 
C)  data redundancy 
D)  excessive storage costs

Question 12

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 13

Replicated databases create considerable data redundancy, which is in conflict with the database concept. Explain the justification of this approach.

Accepted Answer

The primary justification for a replicat

Question 14

Which of the following is not a test of access controls?

Accepted Answer

A)  biometric controls 
B)  encryption controls 
C)  backup controls 
D)  inference controls 
A)  biometric controls 
B)  encryption controls 
C)  backup controls 
D)  inference controls

Question 15

Data normalization groups data attributes into tables in accordance with specific design objectives.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

An entity is any physical thing about which the organization wishes to capture data.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The earliest DBAs were based on the hierarchical data model.

Accepted Answer

A) True 
 B)False

Question 20

What is the internal view of a database?

Accepted Answer

The internal view of a databas

What is a data dictionary, and what purpose does it serve?

Users access the database

Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations.

In a distributed data processing system, a database can be centralized or distributed. What are the options? Explain.

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

Which of the following is not a responsibility of the database management system?

Which term is not associated with the relational database model?

All of the following are basic data management tasks except

The data definition language

The task of searching the database to locate a stored record for processing is called

Which characteristic is associated with the database approach to data management?

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

Replicated databases create considerable data redundancy, which is in conflict with the database concept. Explain the justification of this approach.

Which of the following is not a test of access controls?

Data normalization groups data attributes into tables in accordance with specific design objectives.

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

An entity is any physical thing about which the organization wishes to capture data.

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

The earliest DBAs were based on the hierarchical data model.

What is the internal view of a database?

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Data Structures and Caatts for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Enterprise Resource Planning Systems

Business Ethics, Fraud, and Fraud Detection

Filters

Exam 4: Auditing Database Systems

What is a data dictionary, and what purpose does it serve?

Users access the database

Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations.

In a distributed data processing system, a database can be centralized or distributed. What are the options? Explain.

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

Which of the following is not a responsibility of the database management system?

Which term is not associated with the relational database model?

All of the following are basic data management tasks except

The data definition language

The task of searching the database to locate a stored record for processing is called

Which characteristic is associated with the database approach to data management?

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

Replicated databases create considerable data redundancy, which is in conflict with the database concept. Explain the justification of this approach.

Which of the following is not a test of access controls?

Data normalization groups data attributes into tables in accordance with specific design objectives.

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

An entity is any physical thing about which the organization wishes to capture data.

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

The earliest DBAs were based on the hierarchical data model.

What is the internal view of a database?

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Data Structures and Caatts for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Enterprise Resource Planning Systems

Business Ethics, Fraud, and Fraud Detection

Filters