Question 1

Give an advantage and a disadvantage of the sequential data structure

Accepted Answer

An advantage is that sequential data structures are simple and easy to process.A disadvantage is that processing only a small portion of a large sequential file is inefficient.

Question 2

Which statement is true about a hashing structure?

Accepted Answer

A)  The same address could be calculated for two records. 
B)  Storage space is used efficiently. 
C)  Records cannot be accessed rapidly. 
D)  A separate index is required. 
A)  The same address could be calculated for two records. 
B)  Storage space is used efficiently. 
C)  Records cannot be accessed rapidly. 
D)  A separate index is required. A

Question 3

What are the three physical components of a VSAM file?

Accepted Answer

The three components are the indexes,the prime data storage area,and the overflow area.

Question 4

Explain how a hashing structure works and why it is quicker than using an index.Give an example.If it so much faster,why isn't it used exclusively?

Accepted Answer

A hashing structure typically works by t

Question 5

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 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

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The deletion anomaly may cause data to b

Question 9

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 10

In a hierarchical model

Accepted Answer

A) 
Links between related records are implicit 
B) 
The way to access data is by following a predefined data path 
C) 
An owner (parent) record may own just one member (child) record 
D) 
A member (child) record may have more than one owner (parent) 
A) 
Links between related records are implicit 
B) 
The way to access data is by following a predefined data path 
C) 
An owner (parent) record may own just one member (child) record 
D) 
A member (child) record may have more than one owner (parent)

Question 11

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 12

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER)diagram is t

Question 13

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

Accepted Answer

Data redundancy is not a probl

Question 14

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

Accepted Answer

Where a true 1:1 association exists betw

Question 15

What is a pointer in a data file?

Accepted Answer

A pointer is a field in an ind

Question 16

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs

Question 17

A join builds a new table by creating links.

Accepted Answer

A) True 
 B)False

Question 18

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 19

What are the key control implications of the absence of database normalization?

Accepted Answer

When considering the quality of the data

Question 20

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

Accepted Answer

A) True 
 B)False

Give an advantage and a disadvantage of the sequential data structure

Which statement is true about a hashing structure?

What are the three physical components of a VSAM file?

Explain how a hashing structure works and why it is quicker than using an index.Give an example.If it so much faster,why isn't it used exclusively?

The update anomaly in unnormalized databases

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

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

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

Which statement is not true? Embedded audit modules

In a hierarchical model

Entities are

Explain the purpose of an ER diagram in database design.

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

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

What is a pointer in a data file?

What is a transitive dependency?

A join builds a new table by creating links.

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

What are the key control implications of the absence of database normalization?

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

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

Give an advantage and a disadvantage of the sequential data structure

Which statement is true about a hashing structure?

What are the three physical components of a VSAM file?

Explain how a hashing structure works and why it is quicker than using an index.Give an example.If it so much faster,why isn't it used exclusively?

The update anomaly in unnormalized databases

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

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

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

Which statement is not true? Embedded audit modules

In a hierarchical model

Entities are

Explain the purpose of an ER diagram in database design.

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

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

What is a pointer in a data file?

What is a transitive dependency?

A join builds a new table by creating links.

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

What are the key control implications of the absence of database normalization?

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

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