Question 1

VSAM file structures are most effective where rapid access to individual records is a priority need.

Accepted Answer

A) True 
 B)False

Question 2

A join builds a new table by creating links.

Accepted Answer

A) True 
 B)False

Question 3

A table is in third normal form when it is

Accepted Answer

A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of deletion anomalies 
E)  none of the above 
A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of deletion anomalies 
E)  none of the above

Question 4

Comment on the following statement: "Legacy systems use flat file structures."

Accepted Answer

A flat-file structure is a single-view m

Question 5

What are the three physical components of a VSAM file?

Accepted Answer

The three components

Question 6

Improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly.

Accepted Answer

A) True 
 B)False

Question 7

Generalized audit software packages perform all of the following tasks except

Accepted Answer

A)  recalculate data fields 
B)  compare files and identify differences 
C)  stratify statistical samples 
D)  analyze results and form opinions 
A)  recalculate data fields 
B)  compare files and identify differences 
C)  stratify statistical samples 
D)  analyze results and form opinions

Question 8

Database anomalies are symptoms of structural problems within tables called

Accepted Answer

A)  tuples 
B)  dependencies 
C)  collisions 
D)  Attributes 
A)  tuples 
B)  dependencies 
C)  collisions 
D)  Attributes

Question 9

An advantage of using an indexed random file structure is that records are easily added and deleted.

Accepted Answer

A) True 
 B)False

Question 10

What are the six phases of view modeling?

Accepted Answer

Identify entities.
Construct a data mode

Question 11

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs

Question 12

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 13

Which statement is not true? Embedded audit modules

Accepted Answer

A)  can be turned on and off by the auditor. 
B)  reduce operating efficiency. 
C)  may lose their viability in an environment where programs are modified frequently. 
D)  identify transactions to be analyzed using white box tests. 
A)  can be turned on and off by the auditor. 
B)  reduce operating efficiency. 
C)  may lose their viability in an environment where programs are modified frequently. 
D)  identify transactions to be analyzed using white box tests.

Question 14

The deletion anomaly is the least important of the problems affecting unnormalized databases.

Accepted Answer

A) True 
 B)False

Question 15

In the relational database model all of the following are true except

Accepted Answer

A)  data is presented to users as tables 
B)  data can be extracted from specified rows from specified tables 
C)  a new table can be built by joining two tables 
D)  only one-to-many relationships can be supported 
A)  data is presented to users as tables 
B)  data can be extracted from specified rows from specified tables 
C)  a new table can be built by joining two tables 
D)  only one-to-many relationships can be supported

Question 16

What are the two fundamental components of data structures?

Accepted Answer

Organizati

Question 17

Entities are

Accepted Answer

A)  nouns that are depicted by rectangles on an entity relationship diagram 
B)  data that describe the characteristics of properties of resources 
C)  associations among elements 
D)  sets of data needed to make a decision 
A)  nouns that are depicted by rectangles on an entity relationship diagram 
B)  data that describe the characteristics of properties of resources 
C)  associations among elements 
D)  sets of data needed to make a decision

Question 18

What is repeating group data?

Accepted Answer

Each unique primary

Question 19

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Accepted Answer

A) True 
 B)False

Question 20

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

VSAM file structures are most effective where rapid access to individual records is a priority need.

A join builds a new table by creating links.

A table is in third normal form when it is

Comment on the following statement: "Legacy systems use flat file structures."

What are the three physical components of a VSAM file?

Improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly.

Generalized audit software packages perform all of the following tasks except

Database anomalies are symptoms of structural problems within tables called

An advantage of using an indexed random file structure is that records are easily added and deleted.

What are the six phases of view modeling?

What is a transitive dependency?

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

Which statement is not true? Embedded audit modules

The deletion anomaly is the least important of the problems affecting unnormalized databases.

In the relational database model all of the following are true except

What are the two fundamental components of data structures?

Entities are

What is repeating group data?

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

The physical database is an abstract representation of the database.

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Auditing Database Systems

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Enterprise Resource Planning Systems

Business Ethics, Fraud, and Fraud Detection

Filters

Exam 8: Data Structures and Caatts for Data Extraction

VSAM file structures are most effective where rapid access to individual records is a priority need.

A join builds a new table by creating links.

A table is in third normal form when it is

Comment on the following statement: "Legacy systems use flat file structures."

What are the three physical components of a VSAM file?

Improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly.

Generalized audit software packages perform all of the following tasks except

Database anomalies are symptoms of structural problems within tables called

An advantage of using an indexed random file structure is that records are easily added and deleted.

What are the six phases of view modeling?

What is a transitive dependency?

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

Which statement is not true? Embedded audit modules

The deletion anomaly is the least important of the problems affecting unnormalized databases.

In the relational database model all of the following are true except

What are the two fundamental components of data structures?

Entities are

What is repeating group data?

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

The physical database is an abstract representation of the database.

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Auditing Database Systems

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Enterprise Resource Planning Systems

Business Ethics, Fraud, and Fraud Detection

Filters