Question 1

How does the database approach solve the problem of data redundancy?

Accepted Answer

Data redundancy is not a probl

Question 2

Explain how linkages between relational tables are accomplished.

Accepted Answer

Tables that are logically related in the

Question 3

A table is in second 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 insert 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 insert anomalies 
E)  none of the above

Question 4

GAS can be used with simple data structures but not complex structures

Accepted Answer

A) True 
 B)False

Question 5

The hierarchical database model forces users to navigate between data elements using predefined structured paths.

Accepted Answer

A) True 
 B)False

Question 6

EAM's allow auditors to identify significant transactions for substantive testing.

Accepted Answer

A) True 
 B)False

Question 7

How does the embedded audit module support the auditor?

Accepted Answer

The EAM approach allows selected transac

Question 8

Which of the following is a relational algebra function?

Accepted Answer

A)  restrict 
B)  project 
C)  join 
D)  all are relational algebra functions 
A)  restrict 
B)  project 
C)  join 
D)  all are relational algebra functions

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In a hashing structure,

Accepted Answer

A)  two records can be stored at the same address. 
B)  pointers are used to indicate the location of all records. 
C)  pointers are used to indicate the location of a record with the same address as another record. 
D)  all locations on the disk are used for record storage. 
A)  two records can be stored at the same address. 
B)  pointers are used to indicate the location of all records. 
C)  pointers are used to indicate the location of a record with the same address as another record. 
D)  all locations on the disk are used for record storage.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

When is a table in third normal form (3NF)?

Accepted Answer

A table is in third normal form when it

Question 13

Discuss the two fundamental components of data structures.

Accepted Answer

Organization refers to the way records a

Question 14

In the relational model, a data element is called a relation.

Accepted Answer

A) True 
 B)False

Question 15

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or

Question 16

Explain the basic results that come from the restrict, project, and join functions.

Accepted Answer

A restrict extracts selected rows from a

Question 17

Give an advantage and a disadvantage of the sequential data structure

Accepted Answer

An advantage is that sequentia

Question 18

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER) diagram is

Question 19

An inventory record contains part number, part name, part color, and part weight. These individual items are called

Accepted Answer

A)  fields. 
B)  stored files. 
C)  bytes. 
D)  occurrences. 
A)  fields. 
B)  stored files. 
C)  bytes. 
D)  occurrences.

Question 20

How can a poorly designed database result in unintentional loss of critical records?

Accepted Answer

The deletion anomaly may cause data to b

How does the database approach solve the problem of data redundancy?

Explain how linkages between relational tables are accomplished.

A table is in second normal form when it is

GAS can be used with simple data structures but not complex structures

The hierarchical database model forces users to navigate between data elements using predefined structured paths.

EAM's allow auditors to identify significant transactions for substantive testing.

How does the embedded audit module support the auditor?

Which of the following is a relational algebra function?

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

In a hashing structure,

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

When is a table in third normal form (3NF)?

Discuss the two fundamental components of data structures.

In the relational model, a data element is called a relation.

What is a partial dependency?

Explain the basic results that come from the restrict, project, and join functions.

Give an advantage and a disadvantage of the sequential data structure

Explain the purpose of an ER diagram in database design.

An inventory record contains part number, part name, part color, and part weight. These individual items are called

How can a poorly designed database result in unintentional loss of critical records?

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

How does the database approach solve the problem of data redundancy?

Explain how linkages between relational tables are accomplished.

A table is in second normal form when it is

GAS can be used with simple data structures but not complex structures

The hierarchical database model forces users to navigate between data elements using predefined structured paths.

EAM's allow auditors to identify significant transactions for substantive testing.

How does the embedded audit module support the auditor?

Which of the following is a relational algebra function?

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

In a hashing structure,

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

When is a table in third normal form (3NF)?

Discuss the two fundamental components of data structures.

In the relational model, a data element is called a relation.

What is a partial dependency?

Explain the basic results that come from the restrict, project, and join functions.

Give an advantage and a disadvantage of the sequential data structure

Explain the purpose of an ER diagram in database design.

An inventory record contains part number, part name, part color, and part weight. These individual items are called

How can a poorly designed database result in unintentional loss of critical records?

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