Question 1

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 2

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 3

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

Accepted Answer

A) Social Insurance Number 
B) Phone number 
C) Last name 
D) Office number 
A) Social Insurance Number 
B) Phone number 
C) Last name 
D) Office number

Question 4

The data item which uniquely identifies a computer record in an AIS database table is called the:

Accepted Answer

A) Pointer address 
B) Primary record key 
C) Employee number 
D) Header label 
E) Sort field 
A) Pointer address 
B) Primary record key 
C) Employee number 
D) Header label 
E) Sort field

Question 5

An example of a "one-to-many" relationship is "students to classes."

Accepted Answer

A) True 
 B)False

Question 6

The foreign key in one database table will always be a _______ key in a linked table.

Accepted Answer

A) Secondary key 
B) Domestic key 
C) Primary key 
D) all of these are always true 
A) Secondary key 
B) Domestic key 
C) Primary key 
D) all of these are always true

Question 7

All of the following are items within the data hierarchy except:

Accepted Answer

A) Database 
B) Data field 
C) Record 
D) all of these items are part of the data hierarchy 
A) Database 
B) Data field 
C) Record 
D) all of these items are part of the data hierarchy

Question 8

A Social Insurance Number SIN)is a good example of a useful primary record key.

Accepted Answer

A) True 
 B)False

Question 9

The idea behind concurrency control is to deny several users access to the same database record at the same time.

Accepted Answer

A) True 
 B)False

Question 10

Within a database context, the relationship between "grandparent" and "grandchild" 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 11

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

Accepted Answer

A) Salesperson 
B) Customer 
C) Manager 
D) all of these are possibilities 
A) Salesperson 
B) Customer 
C) Manager 
D) all of these are possibilities

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

All of these are types of record keys except:

Accepted Answer

A) Primary record key 
B) Foreign record key 
C) Tertiary record key 
D) all the above are record key terms 
A) Primary record key 
B) Foreign record key 
C) Tertiary record key 
D) all the above are record key terms

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The "concurrency" control in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

Accepted Answer

A) True 
 B)False

Question 17

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their Social Insurance Number because this would better preserve their privacy.

Accepted Answer

A) True 
 B)False

Question 18

Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating "normal data."

Accepted Answer

A) True 
 B)False

Question 19

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 20

Databases cannot store more than one value in the same data field of the same record.

Accepted Answer

A) True 
 B)False

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

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

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

The data item which uniquely identifies a computer record in an AIS database table is called the:

An example of a "one-to-many" relationship is "students to classes."

The foreign key in one database table will always be a _______ key in a linked table.

All of the following are items within the data hierarchy except:

A Social Insurance Number SIN)is a good example of a useful primary record key.

The idea behind concurrency control is to deny several users access to the same database record at the same time.

Within a database context, the relationship between "grandparent" and "grandchild" would most likely be:

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

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

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

All of these are types of record keys except:

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

The "concurrency" control in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their Social Insurance Number because this would better preserve their privacy.

Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating "normal data."

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

Databases cannot store more than one value in the same data field of the same record.

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

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

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

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

The data item which uniquely identifies a computer record in an AIS database table is called the:

An example of a "one-to-many" relationship is "students to classes."

The foreign key in one database table will always be a _______ key in a linked table.

All of the following are items within the data hierarchy except:

A Social Insurance Number SIN)is a good example of a useful primary record key.

The idea behind concurrency control is to deny several users access to the same database record at the same time.

Within a database context, the relationship between "grandparent" and "grandchild" would most likely be:

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

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

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

All of these are types of record keys except:

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

The "concurrency" control in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their Social Insurance Number because this would better preserve their privacy.

Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating "normal data."

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

Databases cannot store more than one value in the same data field of the same record.

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