Question 1

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Question 4

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 5

It is not possible to create queries for more than on table at a time.

Accepted Answer

A) True 
 B)False

Question 6

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 7

It is not possible to encode search criteria in more than one column of the criteria row in Access.

Accepted Answer

A) True 
 B)False

Question 8

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 in database tables

Question 9

This 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 10

DML stands for "data management logic."

Accepted Answer

A) True 
 B)False

Question 11

Database designers typically store employee Social Security numbers as "Long Integer" data types.

Accepted Answer

A) True 
 B)False

Question 12

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 13

This is the Access tool that prohibits users from deleting parent records with child records (i.e., records related in a one-to-many relationship):

Accepted Answer

A) Referential integrity 
B) Mnemonic naming 
C) Integrative relationships 
D) Data typing 
E) none of these is correct

Question 14

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

Question 15

A database developer can require Access to display records in an ascending sequence using this data field property:

Accepted Answer

A) Organize 
B) Index 
C) Reorganize 
D) Sequencing

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Database management systems can be implemented on:

Accepted Answer

A) Mainframe computers only 
B) Mainframe and minicomputers only 
C) Mainframes, minicomputers, and microcomputers 
D) Microcomputers only

Question 18

Validation rules are useful to prevent data entry errors in databases.

Accepted Answer

A) True 
 B)False

Question 19

Which of these is most likely to represent an input mask for a telephone number in an Access database?

Accepted Answer

A) xxx-xxx-xxxx 
B) abc-def-ghij 
C) ( _ _ _ )_ _ _ - _ _ _ _ 
D) none of these

Question 20

If you wish to create a select query with alternate criteria using Microsoft Access , you should specify them on separate Criteria lines of the query.

Accepted Answer

A) True 
 B)False

Exam 15: Organizing and Manipulating the Data in Databases

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

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

A database management system 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."

It is not possible to create queries for more than on table at a time.

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?

It is not possible to encode search criteria in more than one column of the criteria row in Access.

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

This tool enables a DBMS to extract only a subset of records from a database:

DML stands for "data management logic."

Database designers typically store employee Social Security numbers as "Long Integer" data types.

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

This is the Access tool that prohibits users from deleting parent records with child records (i.e., records related in a one-to-many relationship) :

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

A database developer can require Access to display records in an ascending sequence using this data field property:

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

Database management systems can be implemented on:

Validation rules are useful to prevent data entry errors in databases.

Which of these is most likely to represent an input mask for a telephone number in an Access database?

If you wish to create a select query with alternate criteria using Microsoft Access , you should specify them on separate Criteria lines of the query.