Question 1

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.

Question 2

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 3

Give two limitations of the hierarchical database model?

Accepted Answer

The hierarchical database model forces u

Question 4

In the relational database model

Accepted Answer

A)  relationships are explicit 
B)  the user perceives that files are linked using pointers 
C)  data is represented on two-dimensional tables 
D)  data is represented as a tree structure 
A)  relationships are explicit 
B)  the user perceives that files are linked using pointers 
C)  data is represented on two-dimensional tables 
D)  data is represented as a tree structure

Question 5

Which of the following statements is not true?

Accepted Answer

A)  Indexed random files are dispersed throughout the storage device without regard for physical proximity with related records. 
B)  Indexed random files use disk storage space efficiently. 
C)  Indexed random files are efficient when processing a large portion of a file at one time. 
D)  Indexed random files are easy to maintain in terms of adding records. 
A)  Indexed random files are dispersed throughout the storage device without regard for physical proximity with related records. 
B)  Indexed random files use disk storage space efficiently. 
C)  Indexed random files are efficient when processing a large portion of a file at one time. 
D)  Indexed random files are easy to maintain in terms of adding records.

Question 6

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

Accepted Answer

When considering the quality of the data

Question 7

View modeling begins by identifying the primary entities of the business function in question.

Accepted Answer

A) True 
 B)False

Question 8

A transitive dependency

Accepted Answer

A)  is a database condition that is resolved through special monitoring software. 
B)  is a name given to one of the three anomalies that result from unnormalized database tables. 
C)  can exist only in a table with a composite primary key. 
D)  cannot exist in tables that are normalized at the 3NF level. 
E)  is none of the above. 
A)  is a database condition that is resolved through special monitoring software. 
B)  is a name given to one of the three anomalies that result from unnormalized database tables. 
C)  can exist only in a table with a composite primary key. 
D)  cannot exist in tables that are normalized at the 3NF level. 
E)  is none of the above.

Question 9

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Accepted Answer

A) True 
 B)False

Question 10

What is the update anomaly?

Accepted Answer

The update anomaly results from data red

Question 11

The deletion anomaly in unnormalized databases

Accepted Answer

A)  is easily detected by users 
B)  may result in the loss of important data 
C)  complicates adding records to the database 
D)  requires the user to perform excessive updates 
A)  is easily detected by users 
B)  may result in the loss of important data 
C)  complicates adding records to the database 
D)  requires the user to perform excessive updates

Question 12

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 13

What is view integration?

Accepted Answer

A modern company uses hundreds

Question 14

The database approach to data management is sometimes called the flat file approach.

Accepted Answer

A) True 
 B)False

Question 15

Give an example of the insertion anomaly.

Accepted Answer

The insertion anomaly occurs when certai

Question 16

A user view

Accepted Answer

A)  presents the physical arrangement of records in a database for a particular user 
B)  is the logical abstract structure of the database 
C)  specifies the relationship of data elements in the database 
D)  defines how a particular user sees the database 
A)  presents the physical arrangement of records in a database for a particular user 
B)  is the logical abstract structure of the database 
C)  specifies the relationship of data elements in the database 
D)  defines how a particular user sees the database

Question 17

The two fundamental components of data structures are organization and access method.

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

Outline some of the key advantages of GAS.

Accepted Answer

GAS allows auditors to access electronic

Question 20

Contrast embedded audit modules with generalized audit software.

Accepted Answer

Both techniques permit auditors to acces

Which statement is true about a hashing structure?

In a relational database

Give two limitations of the hierarchical database model?

In the relational database model

Which of the following statements is not true?

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

View modeling begins by identifying the primary entities of the business function in question.

A transitive dependency

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

What is the update anomaly?

The deletion anomaly in unnormalized databases

Pointers can be used for all of the following except

What is view integration?

The database approach to data management is sometimes called the flat file approach.

Give an example of the insertion anomaly.

A user view

The two fundamental components of data structures are organization and access method.

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

Outline some of the key advantages of GAS.

Contrast embedded audit modules with generalized audit software.

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

Which statement is true about a hashing structure?

In a relational database

Give two limitations of the hierarchical database model?

In the relational database model

Which of the following statements is not true?

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

View modeling begins by identifying the primary entities of the business function in question.

A transitive dependency

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

What is the update anomaly?

The deletion anomaly in unnormalized databases

Pointers can be used for all of the following except

What is view integration?

The database approach to data management is sometimes called the flat file approach.

Give an example of the insertion anomaly.

A user view

The two fundamental components of data structures are organization and access method.

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

Outline some of the key advantages of GAS.

Contrast embedded audit modules with generalized audit software.

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