Question 1

Which one of these is not a good guideline to follow when creating tables in a relational database?

Accepted Answer

A) Design first,create tables later 
B) Name tables systematically,using conventional "tbl" prefixes 
C) Use mnemonic names for data fields 
D) Assign at least 50 characters to each text field 
E) Use consistent data types for primary and foreign key fields 
A) Design first,create tables later 
B) Name tables systematically,using conventional "tbl" prefixes 
C) Use mnemonic names for data fields 
D) Assign at least 50 characters to each text field 
E) Use consistent data types for primary and foreign key fields

Question 2

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

Accepted Answer

A) Scrubbing 
B) Sanitizing 
C) Validating 
D) Coding 
A) Scrubbing 
B) Sanitizing 
C) Validating 
D) Coding

Question 3

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

Accepted Answer

A) True 
 B)False

Question 4

You can instruct Access to display a particular error message if you use this property:

Accepted Answer

A) Validation rule 
B) Validation text 
C) Validation message 
D) Validation error 
A) Validation rule 
B) Validation text 
C) Validation message 
D) Validation error

Question 5

Which of these is an example of a data query language?

Accepted Answer

A) ABC 
B) SQL 
C) DDL 
D) JPG 
A) ABC 
B) SQL 
C) DDL 
D) JPG

Question 6

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

Accepted Answer

A) True 
 B)False

Question 7

Using Access,which of these terms is not associated with defining a data field within a record?

Accepted Answer

A) Field name 
B) Data type 
C) Currency value 
D) Description 
A) Field name 
B) Data type 
C) Currency value 
D) Description

Question 8

Database management systems allow their users to create "input masks" which help to prevent input errors.

Accepted Answer

A) True 
 B)False

Question 9

Sorting and Indexing database records are similar in that:

Accepted Answer

A) Neither require underlying table records 
B) Both require the user to first define data validation rules 
C) Both reorganize the way record data appear in outputs 
D) none of these 
A) Neither require underlying table records 
B) Both require the user to first define data validation rules 
C) Both reorganize the way record data appear in outputs 
D) none of these

Question 10

You can increase the prices of selected products systematically using Microsoft's:

Accepted Answer

A) Append query 
B) Update query 
C) Make table query 
D) Delete query 
E) Select query 
A) Append query 
B) Update query 
C) Make table query 
D) Delete query 
E) Select query

Question 11

Pivot tables are powerful statistical tools,but allow the user little flexibility in selecting what data can be analyzed.

Accepted Answer

A) True 
 B)False

Question 12

To create a relationship between two tables in Microsoft Access,you should use the Relationships window.

Accepted Answer

A) True 
 B)False

Question 13

Multimedia databases have rendered traditional text databases useless.

Accepted Answer

A) True 
 B)False

Question 14

A database management system is:

Accepted Answer

A) A set of computer files 
B) A set of one or more computer programs 
C) A set of data to be processed by a computer 
D) A manual accounting information system 
A) A set of computer files 
B) A set of one or more computer programs 
C) A set of data to be processed by a computer 
D) A manual accounting information system

Question 15

A DBMS is an efficient database table in third normal form.

Accepted Answer

A) True 
 B)False

Question 16

The purpose of an input mask is to:

Accepted Answer

A) Disguise data when they are first input into a database 
B) Transform data from alphabetic to numeric formats 
C) Help users avoid data entry errors 
D) Hide sensitive data such as passwords onscreen 
A) Disguise data when they are first input into a database 
B) Transform data from alphabetic to numeric formats 
C) Help users avoid data entry errors 
D) Hide sensitive data such as passwords onscreen

Question 17

Object-oriented databases are used to archive older data that management no longer needs to process.

Accepted Answer

A) True 
 B)False

Question 18

If creating a data mart is not cost effective,management should consider creating a data warehouse,which typically uses less money and time to design.

Accepted Answer

A) True 
 B)False

Question 19

OLAP stands for:

Accepted Answer

A) Object Language for Access Programming 
B) Object Level Analytical Programming 
C) Online Analytical Processing 
D) none of these 
A) Object Language for Access Programming 
B) Object Level Analytical Programming 
C) Online Analytical Processing 
D) none of these

Question 20

An OR operation (query)in Microsoft Access requires you to use

Accepted Answer

A) True 
 B)False

Which one of these is not a good guideline to follow when creating tables in a relational database?

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

You can instruct Access to display a particular error message if you use this property:

Which of these is an example of a data query language?

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

Using Access,which of these terms is not associated with defining a data field within a record?

Database management systems allow their users to create "input masks" which help to prevent input errors.

Sorting and Indexing database records are similar in that:

You can increase the prices of selected products systematically using Microsoft's:

Pivot tables are powerful statistical tools,but allow the user little flexibility in selecting what data can be analyzed.

To create a relationship between two tables in Microsoft Access,you should use the Relationships window.

Multimedia databases have rendered traditional text databases useless.

A database management system is:

A DBMS is an efficient database table in third normal form.

The purpose of an input mask is to:

Object-oriented databases are used to archive older data that management no longer needs to process.

If creating a data mart is not cost effective,management should consider creating a data warehouse,which typically uses less money and time to design.

OLAP stands for:

An OR operation (query)in Microsoft Access requires you to use

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

Which one of these is not a good guideline to follow when creating tables in a relational database?

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

You can instruct Access to display a particular error message if you use this property:

Which of these is an example of a data query language?

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

Using Access,which of these terms is not associated with defining a data field within a record?

Database management systems allow their users to create "input masks" which help to prevent input errors.

Sorting and Indexing database records are similar in that:

You can increase the prices of selected products systematically using Microsoft's:

Pivot tables are powerful statistical tools,but allow the user little flexibility in selecting what data can be analyzed.

To create a relationship between two tables in Microsoft Access,you should use the Relationships window.

Multimedia databases have rendered traditional text databases useless.

A database management system is:

A DBMS is an efficient database table in third normal form.

The purpose of an input mask is to:

Object-oriented databases are used to archive older data that management no longer needs to process.

If creating a data mart is not cost effective,management should consider creating a data warehouse,which typically uses less money and time to design.

OLAP stands for:

An OR operation (query)in Microsoft Access requires you to use

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