Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

An important reason for normalizing data is to eliminate data redundancy.

Accepted Answer

A) True 
 B)False

Question 3

From the following choices, the best example of a primary key for an employee table would be his or her:

Accepted Answer

A) employee number 
B) Phone number 
C) Last name 
D) Office number 
A) employee number 
B) Phone number 
C) Last name 
D) Office number

Question 4

A relational data structure should never be used for accounting systems.

Accepted Answer

A) True 
 B)False

Question 5

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 6

The best choice for the primary key in an "Employees" table would be his or her:

Accepted Answer

A) Last name 
B) First name 
C) Phone number 
D) Employee number 
A) Last name 
B) First name 
C) Phone number 
D) Employee number

Question 7

Within a database context, the relationship between "military commander" 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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 maintained as part of the sales order processing system are:

Accepted Answer

A) Accounts receivable, bill of materials, sales summary 
B) Accounts payable, accounts receivable, finished goods inventory 
C) Accounts receivable, sales summary, operations list 
D) Accounts receivable, finished goods inventory, sales summary 
E) Accounts receivable, sales summary, vendor history 
A) Accounts receivable, bill of materials, sales summary 
B) Accounts payable, accounts receivable, finished goods inventory 
C) Accounts receivable, sales summary, operations list 
D) Accounts receivable, finished goods inventory, sales summary 
E) Accounts receivable, sales summary, vendor history

Question 11

The basic unit of information in a database table of accounting data is a(n):

Accepted Answer

A) Inventory part number 
B) Data field 
C) Computer record 
D) Debit 
A) Inventory part number 
B) Data field 
C) Computer record 
D) Debit

Question 12

A foreign key is a data field in the records of one table that references a primary key in the records of another table.

Accepted Answer

A) True 
 B)False

Question 13

The idea behind view controls is to allow users access to only that information that they need to see.

Accepted Answer

A) True 
 B)False

Question 14

The reason why database designers normalize data is:

Accepted Answer

A) To eliminate data errors and data redundancy 
B) To scale data properly 
C) To create backup copies of data 
D) To create efficient database tables 
A) To eliminate data errors and data redundancy 
B) To scale data properly 
C) To create backup copies of data 
D) To create efficient database tables

Question 15

The terms "parent record," "child record," and "sibling record" describe the records in a:

Accepted Answer

A) Hierarchical database 
B) Network database 
C) Relational database 
D) Flat file 
A) Hierarchical database 
B) Network database 
C) Relational database 
D) Flat file

Question 16

The initials R-E-A in the REA accounting framework refer to "resources, events, and accounting."

Accepted Answer

A) True 
 B)False

Question 17

Big data refers to data that are of large volumes and are unstructured.

Accepted Answer

A) True 
 B)False

Question 18

Within a database context, the relationship between "sales invoice" and "line item" 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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

An important reason for normalizing data is to eliminate data redundancy.

From the following choices, the best example of a primary key for an employee table would be his or her:

A relational data structure should never be used for accounting systems.

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:

The best choice for the primary key in an "Employees" table would be his or her:

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

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

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

The basic unit of information in a database table of accounting data is a(n):

A foreign key is a data field in the records of one table that references a primary key in the records of another table.

The idea behind view controls is to allow users access to only that information that they need to see.

The reason why database designers normalize data is:

The terms "parent record," "child record," and "sibling record" describe the records in a:

The initials R-E-A in the REA accounting framework refer to "resources, events, and accounting."

Big data refers to data that are of large volumes and are unstructured.

Within a database context, the relationship between "sales invoice" and "line item" would most likely be:

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

The process of data normalization refers to:

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

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

An important reason for normalizing data is to eliminate data redundancy.

From the following choices, the best example of a primary key for an employee table would be his or her:

A relational data structure should never be used for accounting systems.

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:

The best choice for the primary key in an "Employees" table would be his or her:

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

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

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

The basic unit of information in a database table of accounting data is a(n):

A foreign key is a data field in the records of one table that references a primary key in the records of another table.

The idea behind view controls is to allow users access to only that information that they need to see.

The reason why database designers normalize data is:

The terms "parent record," "child record," and "sibling record" describe the records in a:

The initials R-E-A in the REA accounting framework refer to "resources, events, and accounting."

Big data refers to data that are of large volumes and are unstructured.

Within a database context, the relationship between "sales invoice" and "line item" would most likely be:

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

The process of data normalization refers to:

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