Question 1

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

Accepted Answer

Open Exclusive

Question 2

The ________ evaluates a database and makes recommendations for optimizing the database.

Accepted Answer

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

Question 3

Which of the following can be tested by creating relationships?

Accepted Answer

A) Normalization 
B) Anomaly 
C) Composite key 
D) Dependencies 
A) Normalization 
B) Anomaly 
C) Composite key 
D) Dependencies A

Question 4

When a database has been converted to an .accde file,it can be converted back to its source format (accdb).

Accepted Answer

A) True 
 B)False

Question 5

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

Accepted Answer

The answer of ________ dependencies occur when the value of...

Question 6

What is the difference between first,second,and third normal form?

Accepted Answer

First normal form removes repeating grou

Question 7

What is database security?

Accepted Answer

A) A specialty within computer security that protects a database application from unintended use 
B) Protecting assets you can touch,such as computers,storage devices,backup tapes,and office safe 
C) Protecting the information that resides on the physical devices,including databases and other computer software 
D) A tabbed menu system that ties the objects in the database together 
A) A specialty within computer security that protects a database application from unintended use 
B) Protecting assets you can touch,such as computers,storage devices,backup tapes,and office safe 
C) Protecting the information that resides on the physical devices,including databases and other computer software 
D) A tabbed menu system that ties the objects in the database together

Question 8

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

Accepted Answer

The Answer of an error or inconsistency that occurs when is...

Question 9

Which Performance Analyzer result requires manual changes?

Accepted Answer

A) Ideas 
B) Suggestions 
C) Recommendations 
D) Indexes 
A) Ideas 
B) Suggestions 
C) Recommendations 
D) Indexes

Question 10

A(n)________ is a rule that indicates the current state of a table.

Accepted Answer

A) normal form 
B) anomaly 
C) normalization 
D) composite key 
A) normal form 
B) anomaly 
C) normalization 
D) composite key

Question 11

What is a certification authority?

Accepted Answer

A) A commercial company that issues and validates identities using digital signatures for a fee 
B) An electronic,encryption-based,secure stamps of authentication 
C) A guarantee that you are the only one using the database 
D) Altering digital information using an algorithm 
A) A commercial company that issues and validates identities using digital signatures for a fee 
B) An electronic,encryption-based,secure stamps of authentication 
C) A guarantee that you are the only one using the database 
D) Altering digital information using an algorithm

Question 12

A table that contains no repeating groups or repeating columns is in:

Accepted Answer

A) first normal form. 
B) second normal form. 
C) third normal form. 
D) fourth normal form. 
A) first normal form. 
B) second normal form. 
C) third normal form. 
D) fourth normal form.

Question 13

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

Accepted Answer

A) second normal form 
B) third normal form 
C) fourth normal form 
D) fifth normal form 
A) second normal form 
B) third normal form 
C) fourth normal form 
D) fifth normal form

Question 14

The main reason to split an Access database is to improve development and maintenance.

Accepted Answer

A) True 
 B)False

Question 15

A back-end database contains the queries,forms,and reports of the database.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT a tool database administrators can use to improve the performance of a database?

Accepted Answer

A) Oracle tool 
B) Database Documenter tool 
C) Performance Analyzer tool 
D) Table Analyzer tool 
A) Oracle tool 
B) Database Documenter tool 
C) Performance Analyzer tool 
D) Table Analyzer tool

Question 19

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

Accepted Answer

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

Question 20

A conversion to a 3NF removes dependencies on part of a composite primary key.

Accepted Answer

A) True 
 B)False

Exam 35: Fine Tuning the Database: Analyzing and Improving Database Performance

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

The ________ evaluates a database and makes recommendations for optimizing the database.

Which of the following can be tested by creating relationships?

When a database has been converted to an .accde file,it can be converted back to its source format (accdb).

________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.

What is the difference between first,second,and third normal form?

What is database security?

Which Performance Analyzer result requires manual changes?

A(n)________ is a rule that indicates the current state of a table.

What is a certification authority?

A table that contains no repeating groups or repeating columns is in:

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

The main reason to split an Access database is to improve development and maintenance.

A back-end database contains the queries,forms,and reports of the database.

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

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Which of the following is NOT a tool database administrators can use to improve the performance of a database?

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

A conversion to a 3NF removes dependencies on part of a composite primary key.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters