Question 1

Database management systems are important to accountants because:

Accepted Answer

A)  They automate file storage tasks and enable accountants to generate worthwhile financial reports
B)  They eliminate data redundancy
C)  They are unique data structures which accountants have never used before
D)  They are easy to develop and therefore save money
E)  They are energy efficient A

Question 2

A "default value" for an Access data field is:

Accepted Answer

A)  The value of last resort
B)  A value that Access will assume if the user does not enter one
C)  A value that Access will take from the last record entered into the system
D)  none of these B

Question 3

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 C

Question 4

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Organizations sometimes pool the historical data from various, separate organizational databases into a common body of information called an):

Accepted Answer

A)  Data pool
B)  Data warehouse
C)  Amazon database
D)  Franchise database

Question 7

When Access links records to one another in different tables, the foreign key in one record refers to the _______ in another record.

Accepted Answer

A)  Primary key
B)  Secondary key
C)  Foreign key
D)  Linkage key

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

Accepted Answer

A)  Perform two separate select queries, using only one zip code for each task
B)  Perform a single select query, placing the zip codes on the same Criteria line of the query
C)  Perform a single select query, placing the zip codes on separate Criteria lines of the query
D)  Perform a single, update query
E)  none of these this is not possible using Microsoft Access)

Question 11

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?

Accepted Answer

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

Question 12

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

Question 13

DML stands for:

Accepted Answer

A)  Distributed management logic
B)  Data management logic
C)  Data management language
D)  Data manipulation language

Question 14

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

Question 15

A dynaset is the total set of records in a database table.

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

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 18

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

Question 19

Which tool enables a DBMS to extract only a subset of records from a database?

Accepted Answer

A)  Table
B)  Query
C)  Validation test
D)  none of these

Question 20

A database subschema is a plot that can often be discovered with forensic accounting.

Accepted Answer

A) True 
 B)False

Exam 4: Organizing and Manipulating the Data in Databases

Database management systems are important to accountants because:

A "default value" for an Access data field is:

The purpose of an input mask is to:

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

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

Organizations sometimes pool the historical data from various, separate organizational databases into a common body of information called an) :

When Access links records to one another in different tables, the foreign key in one record refers to the _______ in another record.

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

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 school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?

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

DML stands for:

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

A dynaset is the total set of records in a database table.

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

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.

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

Which tool enables a DBMS to extract only a subset of records from a database?

A database subschema is a plot that can often be discovered with forensic accounting.