Question 1

Within a database context, the relationship between "students" and "classes" would most likely be:

Accepted Answer

A) one-to-one 
B) one-to-many 
C) many-to-one 
D) many-to-many 
A) one-to-one 
B) one-to-many 
C) many-to-one 
D) many-to-many

Question 2

There are exactly three normal forms.

Accepted Answer

A) True 
 B)False

Question 3

Within a database context, the relationship between "military officer" and "private" would most likely be:

Accepted Answer

A) one-to-one 
B) one-to-many 
C) many-to-one 
D) many-to-many 
A) one-to-one 
B) one-to-many 
C) many-to-one 
D) many-to-many

Question 4

The purpose of the E-R model is to help database designers:

Accepted Answer

A) Identify data redundancies 
B) Create databases in third normal form 
C) Design databases and depict data relationships 
D) Answer structured queries about the data in accounting databases 
A) Identify data redundancies 
B) Create databases in third normal form 
C) Design databases and depict data relationships 
D) Answer structured queries about the data in accounting databases

Question 5

A major advantage of relational databases is:

Accepted Answer

A) All records are stored together 
B) No pointers are used 
C) The ability to add tables and relationships after the database becomes operational 
D) It closely resembles a flat file 
A) All records are stored together 
B) No pointers are used 
C) The ability to add tables and relationships after the database becomes operational 
D) It closely resembles a flat file

Question 6

Within a database context, the relationship between "natural parent" and "child" would most likely be:

Accepted Answer

A) one-to-one 
B) one-to-many 
C) many-to-one 
D) many-to-many 
A) one-to-one 
B) one-to-many 
C) many-to-one 
D) many-to-many

Question 7

The ________ is not necessarily unique for the records in a database table, but is nonetheless often used to locate a particular record:

Accepted Answer

A) Foreign key 
B) Data dictionary 
C) Relationships link bit 
D) Index file 
A) Foreign key 
B) Data dictionary 
C) Relationships link bit 
D) Index file

Question 8

The letter "M" in the acronym DBMS stands for "management."

Accepted Answer

A) True 
 B)False

Question 9

An advantage of relational databases is that additional indexes can be added at later points of time as new data processing requirements dictate.

Accepted Answer

A) True 
 B)False

Question 10

An example of a database cardinality is "one-to-many."

Accepted Answer

A) True 
 B)False

Question 11

In the REA framework, an account receivable would be classified as an):

Accepted Answer

A) Asset 
B) Event 
C) Resource 
D) none of these 
A) Asset 
B) Event 
C) Resource 
D) none of these

Question 12

The correct order of elements, from smallest to largest, in the data hierarchy is data field, file table), record, database.

Accepted Answer

A) True 
 B)False

Question 13

A data dictionary is a computer file describing the data items of an accounting database.

Accepted Answer

A) True 
 B)False

Question 14

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.All of these would be likely data fields in a customer order table except:

Accepted Answer

A) Customer name 
B) Customer number 
C) Date of order 
D) Order number 
A) Customer name 
B) Customer number 
C) Date of order 
D) Order number

Question 15

Controls that do not allow users to update the same database record at the same time are examples of:

Accepted Answer

A) Data integrity controls 
B) Data processing controls 
C) Concurrency controls 
D) Privacy controls 
A) Data integrity controls 
B) Data processing controls 
C) Concurrency controls 
D) Privacy controls

Question 16

In the E-R model, an oval denotes an):

Accepted Answer

A) Data attribute such as a Social Insurance Number 
B) One-to-many relationship 
C) "is a" characteristic 
D) Transitive relationship 
A) Data attribute such as a Social Insurance Number 
B) One-to-many relationship 
C) "is a" characteristic 
D) Transitive relationship

Question 17

The largest unit of information in the data hierarchy is a record.

Accepted Answer

A) True 
 B)False

Question 18

The process of data normalization refers to:

Accepted Answer

A) Eliminating data errors and other problems from "normal data" 
B) Scaling data to values between zero and one 
C) Storing data in normal storage media such as hard disks 
D) none of these 
A) Eliminating data errors and other problems from "normal data" 
B) Scaling data to values between zero and one 
C) Storing data in normal storage media such as hard disks 
D) none of these

Question 19

Three database concerns when creating large databases are "data integrity," "processing accuracy," and "data security."

Accepted Answer

A) True 
 B)False

Question 20

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Accepted Answer

A) Inventory number 
B) Assembly code 
C) Vendor code 
D) Assembly pointer address
The following data apply to items 106-108.The Oxford Corporation has the following eleven master files:
* Accounts payable * Raw materials inventory
* Accounts receivable * Sales summary
* Bill of materials * Vendor history
* Finished goods inventory * Work in process inventory
* Open production orders * Operations list labor operations and
* Open purchase orders machine requirements for production) 
A) Inventory number 
B) Assembly code 
C) Vendor code 
D) Assembly pointer address
The following data apply to items 106-108.The Oxford Corporation has the following eleven master files:
* Accounts payable * Raw materials inventory
* Accounts receivable * Sales summary
* Bill of materials * Vendor history
* Finished goods inventory * Work in process inventory
* Open production orders * Operations list labor operations and
* Open purchase orders machine requirements for production)

Within a database context, the relationship between "students" and "classes" would most likely be:

There are exactly three normal forms.

Within a database context, the relationship between "military officer" and "private" would most likely be:

The purpose of the E-R model is to help database designers:

A major advantage of relational databases is:

Within a database context, the relationship between "natural parent" and "child" would most likely be:

The ________ is not necessarily unique for the records in a database table, but is nonetheless often used to locate a particular record:

The letter "M" in the acronym DBMS stands for "management."

An advantage of relational databases is that additional indexes can be added at later points of time as new data processing requirements dictate.

An example of a database cardinality is "one-to-many."

In the REA framework, an account receivable would be classified as an):

The correct order of elements, from smallest to largest, in the data hierarchy is data field, file table), record, database.

A data dictionary is a computer file describing the data items of an accounting database.

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.All of these would be likely data fields in a customer order table except:

Controls that do not allow users to update the same database record at the same time are examples of:

In the E-R model, an oval denotes an):

The largest unit of information in the data hierarchy is a record.

The process of data normalization refers to:

Three database concerns when creating large databases are "data integrity," "processing accuracy," and "data security."

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Accounting Information Systems and the Accountant

Information Technology and Aiss

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime, Fraud, Ethics, and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting and Enterprise Software

Filters

Exam 3: Data Modeling

Within a database context, the relationship between "students" and "classes" would most likely be:

There are exactly three normal forms.

Within a database context, the relationship between "military officer" and "private" would most likely be:

The purpose of the E-R model is to help database designers:

A major advantage of relational databases is:

Within a database context, the relationship between "natural parent" and "child" would most likely be:

The ________ is not necessarily unique for the records in a database table, but is nonetheless often used to locate a particular record:

The letter "M" in the acronym DBMS stands for "management."

An advantage of relational databases is that additional indexes can be added at later points of time as new data processing requirements dictate.

An example of a database cardinality is "one-to-many."

In the REA framework, an account receivable would be classified as an):

The correct order of elements, from smallest to largest, in the data hierarchy is data field, file table), record, database.

A data dictionary is a computer file describing the data items of an accounting database.

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.All of these would be likely data fields in a customer order table except:

Controls that do not allow users to update the same database record at the same time are examples of:

In the E-R model, an oval denotes an):

The largest unit of information in the data hierarchy is a record.

The process of data normalization refers to:

Three database concerns when creating large databases are "data integrity," "processing accuracy," and "data security."

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Accounting Information Systems and the Accountant

Information Technology and Aiss

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime, Fraud, Ethics, and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting and Enterprise Software

Filters