Question 1

What is the main reason for splitting a database?

Accepted Answer

To improve development and maintenance o

Question 2

What are two formats Database Documenter reports can be saved in?

Accepted Answer

A)  PDF or XPS 
B)  PDF or WPX 
C)  XPS or XLS 
D)  PDF or CSV 
A)  PDF or XPS 
B)  PDF or WPX 
C)  XPS or XLS 
D)  PDF or CSV

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

________ 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 7

Transitive dependencies exist in third normal forms.

Accepted Answer

A) True 
 B)False

Question 8

What is the purpose of a password?

Accepted Answer

To keep unauthorized

Question 9

A digitally signed database requires a password to open it.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Which normal form requires that no transitive dependencies exist?

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 12

________ 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 
A)  Normalization 
B)  Anomaly 
C)  Second normal form 
D)  Transitive dependencies

Question 13

When you use the Database Splitter tool, it splits a database into two files: ________.

Accepted Answer

A)  major and minor 
B)  primary and secondary 
C)  independent and dependent 
D)  front-end and back-end 
A)  major and minor 
B)  primary and secondary 
C)  independent and dependent 
D)  front-end and back-end

Question 14

What appears when you point to a table name of a linked table?

Accepted Answer

A)  ScreenTip 
B)  Splitter 
C)  Table Analyzer 
D)  Wizard 
A)  ScreenTip 
B)  Splitter 
C)  Table Analyzer 
D)  Wizard

Question 15

Minimizing data redundancy is one of the benefits of normalization.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ________ is a primary key that is made up of two or more fields.

Accepted Answer

The answer of A(n) ________ is a primary key that...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Any field that is not part of the primary key is called a(n) ________.

Accepted Answer

The answer of Any field that is not part of...

Question 19

Match between columns
                        Premises: Database Splitter
functional dependency
Table Analyzer
transitive dependencies
Performance Analyzer

Accepted Answer

The Answer of analyzes the tables in a database and is...

Question 20

You would use the Performance Analyzer tool to help reduce data redundancies.

Accepted Answer

A) True 
 B)False

What is the main reason for splitting a database?

What are two formats Database Documenter reports can be saved in?

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

What is a certification authority?

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.

Transitive dependencies exist in third normal forms.

What is the purpose of a password?

A digitally signed database requires a password to open it.

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

Which normal form requires that no transitive dependencies exist?

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

When you use the Database Splitter tool, it splits a database into two files: ________.

What appears when you point to a table name of a linked table?

Minimizing data redundancy is one of the benefits of normalization.

A(n) ________ is a primary key that is made up of two or more fields.

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

Any field that is not part of the primary key is called a(n) ________.

You would use the Performance Analyzer tool to help reduce data redundancies.

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

What is the main reason for splitting a database?

What are two formats Database Documenter reports can be saved in?

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

What is a certification authority?

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.

Transitive dependencies exist in third normal forms.

What is the purpose of a password?

A digitally signed database requires a password to open it.

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

Which normal form requires that no transitive dependencies exist?

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

When you use the Database Splitter tool, it splits a database into two files: ________.

What appears when you point to a table name of a linked table?

Minimizing data redundancy is one of the benefits of normalization.

A(n) ________ is a primary key that is made up of two or more fields.

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

Any field that is not part of the primary key is called a(n) ________.

You would use the Performance Analyzer tool to help reduce data redundancies.

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters