Question 1

The most serious problem with unnormalized databases is the

Accepted Answer

A)  update anomaly 
B)  insertion anomaly 
C)  deletion anomaly 
D)  none of the above 
A)  update anomaly 
B)  insertion anomaly 
C)  deletion anomaly 
D)  none of the above

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational

Question 4

Generalized audit software packages are used to assist the auditor in performing substantive tests.

Accepted Answer

A) True 
 B)False

Question 5

Which statement is correct?

Accepted Answer

A)  in a normalized database, data about vendors occur in several locations 
B)  the accountant is responsible for database normalization 
C)  in a normalized database, deletion of a key record could result in the destruction of the audit trail 
D)  connections between M:M tables are provided by a link table 
A)  in a normalized database, data about vendors occur in several locations 
B)  the accountant is responsible for database normalization 
C)  in a normalized database, deletion of a key record could result in the destruction of the audit trail 
D)  connections between M:M tables are provided by a link table

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A table is in third normal form when it

Question 8

Explain how a separate linking file works in a network model.

Accepted Answer

A network model allows parents to have m

Question 9

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Describe a specific data element,entity,and record type in the expenditure cycle.

Accepted Answer

data element: vendor's name or

Question 12

Give three examples that illustrate how cardinality reflects an organization's underlying business rules.

Accepted Answer

1) When an organization decides to purch

Question 13

Pointers can be used for all of the following except

Accepted Answer

A) to locate the subschema address of the record. 
B) to locate the physical address of the record. 
C) to locate the relative address of the record. 
D) to locate the logical key of the record. 
A) to locate the subschema address of the record. 
B) to locate the physical address of the record. 
C) to locate the relative address of the record. 
D) to locate the logical key of the record.

Question 14

An ER diagram is a graphical representation of a data model.

Accepted Answer

A) True 
 B)False

Question 15

It is appropriate to use a sequential file structure when

Accepted Answer

A) records are routinely inserted. 
B) single records need to be retrieved. 
C) records need to be scanned using secondary keys. 
D)  a large portion of the file will be processed in one operation. 
A) records are routinely inserted. 
B) single records need to be retrieved. 
C) records need to be scanned using secondary keys. 
D)  a large portion of the file will be processed in one operation.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A flat-file structure is a single-view m

Question 18

What is view integration?

Accepted Answer

A modern company uses hundreds

Question 19

In a relational database

Accepted Answer

A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL) is used to create a user's view of the database 
A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL) is used to create a user's view of the database

Question 20

Explain the following three types of pointers: physical address pointer,relative address pointer,and logical key pointer.

Accepted Answer

A physical address pointer contains the

The most serious problem with unnormalized databases is the

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

Why are the hierarchical and network models called navigational databases?

Generalized audit software packages are used to assist the auditor in performing substantive tests.

Which statement is correct?

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

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

Explain how a separate linking file works in a network model.

What is a partial dependency?

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

Describe a specific data element,entity,and record type in the expenditure cycle.

Give three examples that illustrate how cardinality reflects an organization's underlying business rules.

Pointers can be used for all of the following except

An ER diagram is a graphical representation of a data model.

It is appropriate to use a sequential file structure when

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

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

What is view integration?

In a relational database

Explain the following three types of pointers: physical address pointer,relative address pointer,and logical key pointer.

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

IT Security Part II: Auditing Database Systems

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Enterprise Resource Planning Systems

Filters

Exam 8: Data Structures and CAATTs for Data Extraction

The most serious problem with unnormalized databases is the

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

Why are the hierarchical and network models called navigational databases?

Generalized audit software packages are used to assist the auditor in performing substantive tests.

Which statement is correct?

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

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

Explain how a separate linking file works in a network model.

What is a partial dependency?

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

Describe a specific data element,entity,and record type in the expenditure cycle.

Give three examples that illustrate how cardinality reflects an organization's underlying business rules.

Pointers can be used for all of the following except

An ER diagram is a graphical representation of a data model.

It is appropriate to use a sequential file structure when

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

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

What is view integration?

In a relational database

Explain the following three types of pointers: physical address pointer,relative address pointer,and logical key pointer.

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

IT Security Part II: Auditing Database Systems

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Enterprise Resource Planning Systems

Filters