Question 1

Which of these comes closest in structure to that of a hierarchical database?

Accepted Answer

A) Organization chart 
B) List of students and their classes 
C) List of specialty doctors and their patients 
D) A map of a city 
A) Organization chart 
B) List of students and their classes 
C) List of specialty doctors and their patients 
D) A map of a city

Question 2

Which of these would be an example of a "resource" in the REA framework?

Accepted Answer

A) Equipment 
B) Inventory 
C) Cash 
D) all of these are possible examples of resources 
A) Equipment 
B) Inventory 
C) Cash 
D) all of these are possible examples of resources

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

In the REA framework, a database designer should create a ____ for each entity.

Accepted Answer

A) Record 
B) Table 
C) Secondary key 
D) all of these 
A) Record 
B) Table 
C) Secondary key 
D) all of these

Question 8

In the E-R model, this symbol represents a database entity such as a customer:

Accepted Answer

A) Diamond 
B) Rectangle 
C) Arrow 
D) Parallelogram 
A) Diamond 
B) Rectangle 
C) Arrow 
D) Parallelogram

Question 9

A sale is an example of an event in the REA accounting framework.

Accepted Answer

A) True 
 B)False

Question 10

The basic unit of information in an accounting information database is a table.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Edit tests that catch data entry errors are examples of:

Accepted Answer

A) Data integrity controls 
B) Corporate ethics 
C) Concurrency controls 
D) Privacy controls 
A) Data integrity controls 
B) Corporate ethics 
C) Concurrency controls 
D) Privacy controls

Question 13

An example of a "one-to-one" relationship is "employee to assigned parking stall."

Accepted Answer

A) True 
 B)False

Question 14

The Oxford Corporation has the following eleven master files: 
* Accounts payable$\quad $$\quad $$\quad $* Raw materials inventory
* Accounts receivable$\quad $ $\quad $*Sales summary
* Bill of materials$\quad $$\quad $$\quad $$\quad $* Vendor history
* Finished goods inventory$\quad $* Work in process inventory
* Open production orders$\quad $$\quad $* Operations list (labor operations and
* Open purchase orders $\quad $$\quad $machine requirements for production)

-Master files that are maintained as part of the processing of purchase transactions are:

Accepted Answer

A) Accounts payable, bill of materials, finished goods inventory, open purchase orders 
B) Accounts payable, open purchase orders, raw materials inventory, work in process inventory 
C) Accounts payable, bill of materials, open purchase orders, vendor history 
D) Accounts payable, finished goods inventory, open purchase orders, vendor history 
E) Accounts payable, open purchase orders, raw materials inventory, vendor history 
A) Accounts payable, bill of materials, finished goods inventory, open purchase orders 
B) Accounts payable, open purchase orders, raw materials inventory, work in process inventory 
C) Accounts payable, bill of materials, open purchase orders, vendor history 
D) Accounts payable, finished goods inventory, open purchase orders, vendor history 
E) Accounts payable, open purchase orders, raw materials inventory, vendor history

Question 15

An employee number is a good example of a useful primary record key.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not an objective of a computerized database?

Accepted Answer

A) Minimize data redundancy 
B) Make efficient use of storage media 
C) Distribute information to end users 
D) Eliminate the data?gathering responsibilities of some subsystems within the organization 
E) Reduce the decision?making functions of subsystem managers 
A) Minimize data redundancy 
B) Make efficient use of storage media 
C) Distribute information to end users 
D) Eliminate the data?gathering responsibilities of some subsystems within the organization 
E) Reduce the decision?making functions of subsystem managers

Question 17

This item helps developers document a database:

Accepted Answer

A) Data documentation detailer (DD
D)  
B) Data dictionary 
C) Database schema system 
D) Data OLAP system 
A) Data documentation detailer (DD
D)  
B) Data dictionary 
C) Database schema system 
D) Data OLAP system

Question 18

A database is in third normal form if all of its records are in second normal form, and there are no transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

An example of a transitive relationship in a medical application is the one between "doctor number" and "patient name."

Accepted Answer

A) True 
 B)False

Which of these comes closest in structure to that of a hierarchical database?

Which of these would be an example of a "resource" in the REA framework?

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

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

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

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

In the REA framework, a database designer should create a ____ for each entity.

In the E-R model, this symbol represents a database entity such as a customer:

A sale is an example of an event in the REA accounting framework.

The basic unit of information in an accounting information database is a table.

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

Edit tests that catch data entry errors are examples of:

An example of a "one-to-one" relationship is "employee to assigned parking stall."

An employee number is a good example of a useful primary record key.

Which of the following is not an objective of a computerized database?

This item helps developers document a database:

A database is in third normal form if all of its records are in second normal form, and there are no transitive dependencies.

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

An example of a transitive relationship in a medical application is the one between "doctor number" and "patient name."

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Filters

Exam 14: Database Design

Which of these comes closest in structure to that of a hierarchical database?

Which of these would be an example of a "resource" in the REA framework?

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

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

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

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

In the REA framework, a database designer should create a ____ for each entity.

In the E-R model, this symbol represents a database entity such as a customer:

A sale is an example of an event in the REA accounting framework.

The basic unit of information in an accounting information database is a table.

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

Edit tests that catch data entry errors are examples of:

An example of a "one-to-one" relationship is "employee to assigned parking stall."

An employee number is a good example of a useful primary record key.

Which of the following is not an objective of a computerized database?

This item helps developers document a database:

A database is in third normal form if all of its records are in second normal form, and there are no transitive dependencies.

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

An example of a transitive relationship in a medical application is the one between "doctor number" and "patient name."

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Filters