Question 1

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  True

Question 2

The term "transaction control" refers to the requirement that a database system either process a transaction entirely,or not at all.

Accepted Answer

A) True 
 B)False  True

Question 3

An example of a transitive relationship in a parking-tickets application is the one between "ticket code" and "fine amount."

Accepted Answer

A) True 
 B)False  True

Question 4

A data dictionary can help an accountant:

Accepted Answer

A) Prepare tax forms for the IRS 
B) Establish an audit trail 
C) Correct clerical mistakes in transaction data 
D) Perform an audit of the petty cash fund 
A) Prepare tax forms for the IRS 
B) Establish an audit trail 
C) Correct clerical mistakes in transaction data 
D) Perform an audit of the petty cash fund

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following creates relationships by linking the data in one file (e.g.,customer)to an item in a second file (e.g.,a sales order)?

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

The E-R model refers to the "entity-relationship" model.

Accepted Answer

A) True 
 B)False

Question 10

The smallest unit of information in the data hierarchy is a data field.

Accepted Answer

A) True 
 B)False

Question 11

A last name such as "Smith" is an example of a useful primary record key.

Accepted Answer

A) True 
 B)False

Question 12

A data dictionary:

Accepted Answer

A) Is a book defining computer terms 
B) Is a reference document describing how accounting data are collected 
C) Is usually a computer file that maintains descriptive information about the data items of an accounting information system 
D) all of the above 
A) Is a book defining computer terms 
B) Is a reference document describing how accounting data are collected 
C) Is usually a computer file that maintains descriptive information about the data items of an accounting information system 
D) all of the above

Question 13

The basic unit of information in an accounting information system database is the debit.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

An example of a transitive dependency in a database is:

Accepted Answer

A) Student  grade 
B) Telephone area code  phone number 
C) Airline  flight number 
D) Parking Code  parking fine amount 
A) Student  grade 
B) Telephone area code  phone number 
C) Airline  flight number 
D) Parking Code  parking fine amount

Question 16

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

Accepted Answer

A) True 
 B)False

Question 17

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 18

The basic unit of information on a computer file of accounting data is a(n):

Accepted Answer

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

Question 19

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 20

This type of database structure enables users to create relationships after the database has been created and implemented:

Accepted Answer

A) Hierarchical 
B) Network 
C) Star 
D) Relational 
A) Hierarchical 
B) Network 
C) Star 
D) Relational

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

The term "transaction control" refers to the requirement that a database system either process a transaction entirely,or not at all.

An example of a transitive relationship in a parking-tickets application is the one between "ticket code" and "fine amount."

A data dictionary can help an accountant:

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

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

Which of the following creates relationships by linking the data in one file (e.g.,customer)to an item in a second file (e.g.,a sales order)?

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

The E-R model refers to the "entity-relationship" model.

The smallest unit of information in the data hierarchy is a data field.

A last name such as "Smith" is an example of a useful primary record key.

A data dictionary:

The basic unit of information in an accounting information system database is the debit.

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

An example of a transitive dependency in a database is:

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

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

The basic unit of information on a computer file of accounting data is a(n):

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

This type of database structure enables users to create relationships after the database has been created and implemented:

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

Documenting Accounting Information Systems

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 on the Internet

Filters

Exam 3: Data Modeling

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

The term "transaction control" refers to the requirement that a database system either process a transaction entirely,or not at all.

An example of a transitive relationship in a parking-tickets application is the one between "ticket code" and "fine amount."

A data dictionary can help an accountant:

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

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

Which of the following creates relationships by linking the data in one file (e.g.,customer)to an item in a second file (e.g.,a sales order)?

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

The E-R model refers to the "entity-relationship" model.

The smallest unit of information in the data hierarchy is a data field.

A last name such as "Smith" is an example of a useful primary record key.

A data dictionary:

The basic unit of information in an accounting information system database is the debit.

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

An example of a transitive dependency in a database is:

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

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

The basic unit of information on a computer file of accounting data is a(n):

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

This type of database structure enables users to create relationships after the database has been created and implemented:

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

Documenting Accounting Information Systems

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 on the Internet

Filters