Question 1

How does Access handle multivalued fields?

Accepted Answer

A)  Creates special invisible tables in the background 
B)  Appear as repeating groups in the table 
C)  Makes the multivalue field dependent on the primary key 
D)  Removes dependencies on required fields

Question 2

________ is the formal process of deciding which fields should be grouped together into which table.

Accepted Answer

A)  Normalization 
B)  Anomaly 
C)  Second normal form 
D)  Transitive dependencies

Question 3

In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.

Accepted Answer

The answer of In the Navigation Pane,________ tables have an...

Question 4

A good password should be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

Accepted Answer

A) True 
 B)False

Question 5

The Performance Analyzer lists three kinds of analysis results: recommendations,suggestions,and ideas.

Accepted Answer

A) True 
 B)False

Question 6

What does the Database Documenter list?

Accepted Answer

The answer of What does the Database Documenter list?...

Question 7

Which process guarantees that you are the only one currently using the database?

Accepted Answer

A)  Open exclusive 
B)  Encryption 
C)  Password protect 
D)  Selfcert

Question 8

Which tool does NOT identify flaws in the design of the database?

Accepted Answer

A)  Database Documenter 
B)  Performance Analyzer 
C)  Table Analyzer 
D)  Document Splitter

Question 9

Match between columns
                        Premises: composite key
anomaly
encryption
non-key field

Accepted Answer

The Answer of a primary key that is made up is...

Question 10

________ mode guarantees that you are the only one currently using the database.

Accepted Answer

The answer of ________ mode guarantees that you are the...

Question 11

What are three useful Access tools that database administrators can use to improve the performance of a database?

Accepted Answer

The answer of What are three useful Access tools that...

Question 12

The formal process of deciding which fields should be grouped together into which fields is called ________.

Accepted Answer

The answer of The formal process of deciding which fields...

Question 13

A(n)________ is an error or inconsistency within a database.

Accepted Answer

A)  anomaly 
B)  normalization 
C)  first normal form 
D)  non-key field

Question 14

________ is the protection of data from unauthorized access,change,or destruction.

Accepted Answer

A)  Computer security 
B)  Improved performance 
C)  Encryption 
D)  Flexible Environment

Question 15

A method to encrypt a database is to assign a password to the file.

Accepted Answer

A) True 
 B)False

Question 16

Normalization rules indicate the current state of a table.

Accepted Answer

A) True 
 B)False

Question 17

First normal form is a table that contains no repeating groups or repeating columns.

Accepted Answer

A) True 
 B)False

Question 18

A navigation form is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

Accepted Answer

A) True 
 B)False

Question 19

What is the purpose of a password?

Accepted Answer

The answer of What is the purpose of a password?...

Question 20

You cannot create an ACCDE file unless you have enabled the content in the database.

Accepted Answer

A) True 
 B)False

Exam 21: Fine-Tuning the Database: Analyzing and Improving Database Performance

How does Access handle multivalued fields?

________ is the formal process of deciding which fields should be grouped together into which table.

In the Navigation Pane,________ tables have an arrow icon to indicate they are linked to another Access database.

A good password should be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

The Performance Analyzer lists three kinds of analysis results: recommendations,suggestions,and ideas.

What does the Database Documenter list?

Which process guarantees that you are the only one currently using the database?

Which tool does NOT identify flaws in the design of the database?

Match the following terms with their meanings:

________ mode guarantees that you are the only one currently using the database.

What are three useful Access tools that database administrators can use to improve the performance of a database?

The formal process of deciding which fields should be grouped together into which fields is called ________.

A(n) ________ is an error or inconsistency within a database.

________ is the protection of data from unauthorized access,change,or destruction.

A method to encrypt a database is to assign a password to the file.

Normalization rules indicate the current state of a table.

First normal form is a table that contains no repeating groups or repeating columns.

A navigation form is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

What is the purpose of a password?

You cannot create an ACCDE file unless you have enabled the content in the database.