Question 1

Data warehouses are only used for analyzing current accounting data.

Accepted Answer

A) True 
 B)False

Question 2

The purpose of using validation tests in the record definition of a database is to:

Accepted Answer

A) Make sure the database works properly 
B) Avoid data entry errors 
C) Ensure normalized data 
D) Verify that the user is authorized to enter data in the database 
A) Make sure the database works properly 
B) Avoid data entry errors 
C) Ensure normalized data 
D) Verify that the user is authorized to enter data in the database

Question 3

All of these are characteristics of the data stored in a data warehouse except:

Accepted Answer

A) Data are clean of errors 
B) Data are defined uniformly 
C) Data are stored in consistent formats 
D) Data are simplified,and thus cannot be used to answer complex questions 
A) Data are clean of errors 
B) Data are defined uniformly 
C) Data are stored in consistent formats 
D) Data are simplified,and thus cannot be used to answer complex questions

Question 4

These databases can include graphics,audio,and animation:

Accepted Answer

A) Multidimensional databases 
B) Hierarchical databases 
C) Object-oriented databases 
D) Multimedia databases 
A) Multidimensional databases 
B) Hierarchical databases 
C) Object-oriented databases 
D) Multimedia databases

Question 5

Microsoft uses this symbol to represent the "many" side of a "one-to-many" relationship:

Accepted Answer

A) & 
B) N 
C) √ 
D) ∞ 
A) & 
B) N 
C) √ 
D) ∞

Question 6

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Parental Hierarchy" in Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 7

Online analytical processing enables a computer system to display information that must be computed from the data stored in a database.

Accepted Answer

A) True 
 B)False

Question 8

Which of these terms is synonymous with the term "combo box?"

Accepted Answer

A) Collection box 
B) Textbox 
C) Criteria line 
D) Drop-down box 
A) Collection box 
B) Textbox 
C) Criteria line 
D) Drop-down box

Question 9

An advantage of using a drop-down box in an Access database is that:

Accepted Answer

A) It helps users avoid input errors 
B) It provides an input mask for data entries 
C) It automatically screens numeric data for incorrect values 
D) all of these are correct 
A) It helps users avoid input errors 
B) It provides an input mask for data entries 
C) It automatically screens numeric data for incorrect values 
D) all of these are correct

Question 10

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

Accepted Answer

A) Text 
B) Number 
C) Memo 
D) Percent 
E) all of these are legitimate data types 
A) Text 
B) Number 
C) Memo 
D) Percent 
E) all of these are legitimate data types

Question 11

An advantage of defining a default value for an Access data field is that it:

Accepted Answer

A) Assures that the data in all records will be exactly the same for that field 
B) Eliminates data redundancy 
C) Helps create subsequent queries on that field 
D) Saves typing,and probably errors 
A) Assures that the data in all records will be exactly the same for that field 
B) Eliminates data redundancy 
C) Helps create subsequent queries on that field 
D) Saves typing,and probably errors

Question 12

An advantage of a multimedia database is that:

Accepted Answer

A) They can store graphics and pictures as well as numeric data 
B) They are also object-oriented databases 
C) They allow users to upload pictures in web applications 
D) all of these are advantages 
A) They can store graphics and pictures as well as numeric data 
B) They are also object-oriented databases 
C) They allow users to upload pictures in web applications 
D) all of these are advantages

Question 13

In Access,a validation rule triggers at the time when:

Accepted Answer

A) The user enters a value that falls outside the allowable range 
B) The DBMS first uses the data in a report 
C) The user first requests the database to test data with a menu command 
D) The user powers up Access and loads that particular database 
A) The user enters a value that falls outside the allowable range 
B) The DBMS first uses the data in a report 
C) The user first requests the database to test data with a menu command 
D) The user powers up Access and loads that particular database

Question 14

A dynaset is the set of records that results from a query.

Accepted Answer

A) True 
 B)False

Question 15

As a general rule,creating data warehouses is:

Accepted Answer

A) Easy 
B) Habit forming 
C) Challenging but often worth the cost 
D) Challenging,and historically rarely worth the cost 
A) Easy 
B) Habit forming 
C) Challenging but often worth the cost 
D) Challenging,and historically rarely worth the cost

Question 16

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

Accepted Answer

A) Multidimensional database 
B) Hierarchical database 
C) Object oriented database 
D) Data dictionary 
A) Multidimensional database 
B) Hierarchical database 
C) Object oriented database 
D) Data dictionary

Question 17

When purchasing a new database management system,managers should focus on the system's technological capabilities rather than its compatibility with current systems.

Accepted Answer

A) True 
 B)False

Question 18

It is not possible to save a table in Microsoft Access unless you also identify a primary record key.

Accepted Answer

A) True 
 B)False

Question 19

The guideline recommending that you create "mnemonic names for data fields" means that you should name data fields that rhyme with their data types.

Accepted Answer

A) True 
 B)False

Question 20

A DBMS is a type of hardware.

Accepted Answer

A) True 
 B)False

Data warehouses are only used for analyzing current accounting data.

The purpose of using validation tests in the record definition of a database is to:

All of these are characteristics of the data stored in a data warehouse except:

These databases can include graphics,audio,and animation:

Microsoft uses this symbol to represent the "many" side of a "one-to-many" relationship:

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Parental Hierarchy" in Microsoft Access.

Online analytical processing enables a computer system to display information that must be computed from the data stored in a database.

Which of these terms is synonymous with the term "combo box?"

An advantage of using a drop-down box in an Access database is that:

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

An advantage of defining a default value for an Access data field is that it:

An advantage of a multimedia database is that:

In Access,a validation rule triggers at the time when:

A dynaset is the set of records that results from a query.

As a general rule,creating data warehouses is:

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

When purchasing a new database management system,managers should focus on the system's technological capabilities rather than its compatibility with current systems.

It is not possible to save a table in Microsoft Access unless you also identify a primary record key.

The guideline recommending that you create "mnemonic names for data fields" means that you should name data fields that rhyme with their data types.

A DBMS is a type of hardware.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

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 4: Organizing and Manipulating the Data in Databases

Data warehouses are only used for analyzing current accounting data.

The purpose of using validation tests in the record definition of a database is to:

All of these are characteristics of the data stored in a data warehouse except:

These databases can include graphics,audio,and animation:

Microsoft uses this symbol to represent the "many" side of a "one-to-many" relationship:

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Parental Hierarchy" in Microsoft Access.

Online analytical processing enables a computer system to display information that must be computed from the data stored in a database.

Which of these terms is synonymous with the term "combo box?"

An advantage of using a drop-down box in an Access database is that:

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

An advantage of defining a default value for an Access data field is that it:

An advantage of a multimedia database is that:

In Access,a validation rule triggers at the time when:

A dynaset is the set of records that results from a query.

As a general rule,creating data warehouses is:

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

When purchasing a new database management system,managers should focus on the system's technological capabilities rather than its compatibility with current systems.

It is not possible to save a table in Microsoft Access unless you also identify a primary record key.

The guideline recommending that you create "mnemonic names for data fields" means that you should name data fields that rhyme with their data types.

A DBMS is a type of hardware.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

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