Question 1

View modeling includes

Accepted Answer

A)  constructing a data model showing entity associations. 
B)  constructing the physical database. 
C)  preparing the user views. 
D)  all of the above. 
A)  constructing a data model showing entity associations. 
B)  constructing the physical database. 
C)  preparing the user views. 
D)  all of the above. D

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Question 4

When a large portion of the file is to be processed in one operation such as payroll, sequential data structures are an inefficient method of organizing a file.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

1) When an organization decides to purch

Question 6

Which statement is not correct? The VSAM structure

Accepted Answer

A)  is used for very large files that need both direct access and batch processing. 
B)  may use an overflow area for records. 
C)  provides an exact physical address for each record. 
D)  is appropriate for files that require few insertions or deletions. 
A)  is used for very large files that need both direct access and batch processing. 
B)  may use an overflow area for records. 
C)  provides an exact physical address for each record. 
D)  is appropriate for files that require few insertions or deletions.

Question 7

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 8

What is a hashing structure? What are the advantage(s) and disadvantage(s) associated with it?

Accepted Answer

A hashing structure employs an algorithm

Question 9

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 10

A table in third normal form is free of partial dependencies, multiple dependencies, and transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 11

Each of the following is a relational algebra function except

Accepted Answer

A)  join 
B)  project 
C)  link 
D)  restrict 
A)  join 
B)  project 
C)  link 
D)  restrict

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

What is the relationship between a database table and a user view?

Accepted Answer

User views are derived databas

Question 15

The update anomaly in unnormalized databases

Accepted Answer

A)  occurs because of data redundancy 
B)  complicates adding records to the database 
C)  may result in the loss of important data 
D)  often results in excessive record insertions 
A)  occurs because of data redundancy 
B)  complicates adding records to the database 
C)  may result in the loss of important data 
D)  often results in excessive record insertions

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Explain the three types of anomalies associated with database tables that have not been normalized.

Accepted Answer

The update anomaly is the result of data

Question 18

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 19

Pointers are used

Accepted Answer

A)  to link records within a file. 
B)  to link records between files. 
C)  to identify records stored in overflow. 
D)  all of the above. 
A)  to link records within a file. 
B)  to link records between files. 
C)  to identify records stored in overflow. 
D)  all of the above.

Question 20

Under the database approach, data is viewed as proprietary or owned by users.

Accepted Answer

A) True 
 B)False

View modeling includes

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

A table is in first normal form when it is

When a large portion of the file is to be processed in one operation such as payroll, sequential data structures are an inefficient method of organizing a file.

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

Which statement is not correct? The VSAM structure

It is appropriate to use a sequential file structure when

What is a hashing structure? What are the advantage(s) and disadvantage(s) associated with it?

The most serious problem with unnormalized databases is the

A table in third normal form is free of partial dependencies, multiple dependencies, and transitive dependencies.

Each of the following is a relational algebra function except

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

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

What is the relationship between a database table and a user view?

The update anomaly in unnormalized databases

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

Explain the three types of anomalies associated with database tables that have not been normalized.

Which statement is correct?

Pointers are used

Under the database approach, data is viewed as proprietary or owned by users.

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

View modeling includes

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

A table is in first normal form when it is

When a large portion of the file is to be processed in one operation such as payroll, sequential data structures are an inefficient method of organizing a file.

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

Which statement is not correct? The VSAM structure

It is appropriate to use a sequential file structure when

What is a hashing structure? What are the advantage(s) and disadvantage(s) associated with it?

The most serious problem with unnormalized databases is the

A table in third normal form is free of partial dependencies, multiple dependencies, and transitive dependencies.

Each of the following is a relational algebra function except

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

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

What is the relationship between a database table and a user view?

The update anomaly in unnormalized databases

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

Explain the three types of anomalies associated with database tables that have not been normalized.

Which statement is correct?

Pointers are used

Under the database approach, data is viewed as proprietary or owned by users.

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