Question 1

One way to bring a database into 3NF compliance is to delete all unnecessary fields.

Accepted Answer

A) True 
 B)False

Question 2

Addressing transitive dependencies happens when you are attempting to bring your database into compliance with what normal form?

Accepted Answer

A) First 
B) Second 
C) Third 
D) Fourth 
A) First 
B) Second 
C) Third 
D) Fourth

Question 3

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

Accepted Answer

A) True 
 B)False

Question 4

DBMS stands for Database ________ System.

Accepted Answer

The answer of DBMS stands for Database ________ System....

Question 5

A table with a single-field primary key is usually in compliance with what normal form?

Accepted Answer

A) First 
B) Second 
C) Third 
D) Fourth 
A) First 
B) Second 
C) Third 
D) Fourth

Question 6

Logical security involves the information that is found on physical devices.

Accepted Answer

A) True 
 B)False

Question 7

Which tool creates a detailed report for each selected object?

Accepted Answer

A) Report Wizard 
B) Database Reporter 
C) Database Documenter 
D) Object Documenter 
A) Report Wizard 
B) Database Reporter 
C) Database Documenter 
D) Object Documenter

Question 8

What does ACCDE stand for?

Accepted Answer

A) Access Database Extended 
B) Access Database Example 
C) Access Database Evaluation 
D) Access Database Executable 
A) Access Database Extended 
B) Access Database Example 
C) Access Database Evaluation 
D) Access Database Executable

Question 9

As new tables,queries,forms,and reports are added to a database,Access actually becomes more efficient and the performance of the database increases.

Accepted Answer

A) True 
 B)False

Question 10

The ________ Analyzer tool makes suggestions to minimizing the duplication of data.

Accepted Answer

The answer of The ________ Analyzer tool makes suggestions to...

Question 11

DBMS stands for ________.

Accepted Answer

A) Data Marketing System 
B) Data Management System 
C) Database Marketing System 
D) Database Management System 
A) Data Marketing System 
B) Data Management System 
C) Database Marketing System 
D) Database Management System

Question 12

Which database tool turns your database into two files?

Accepted Answer

A) Database Divider 
B) Database Splitter 
C) Database Division 
D) Database Performance 
A) Database Divider 
B) Database Splitter 
C) Database Division 
D) Database Performance

Question 13

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

Accepted Answer

The answer of A(n)________ is an error or inconsistency within...

Question 14

Which is not a benefit of normalization?

Accepted Answer

A) It improves referential integrity enforcement. 
B) It minimizes data redundancy. 
C) It accommodates future growth of the database. 
D) It allows more than one person to use the data at the same time. 
A) It improves referential integrity enforcement. 
B) It minimizes data redundancy. 
C) It accommodates future growth of the database. 
D) It allows more than one person to use the data at the same time.

Question 15

Match between columns
                        Premises: First normal form
Normalization
Normal forms
Third normal form
Second normal form

Accepted Answer

The Answer of All non-key fields are functionally dependent on is...

Question 16

Including capital letters,numbers,and special characters help to make the password more secure.

Accepted Answer

A) True 
 B)False

Question 17

What are the rules to optimize and fix potential repetition issues in a database known as?

Accepted Answer

A) Encryption 
B) Normal forms 
C) Data validation 
D) Table Analyzer tool 
A) Encryption 
B) Normal forms 
C) Data validation 
D) Table Analyzer tool

Question 18

The best way to use the Database Documenter tool is to select every option,otherwise you might miss including important data.

Accepted Answer

A) True 
 B)False

Question 19

If an Author field lists multiple authors separated by commas like Poatsy,Rutledge,and Williams,this would be in violation of the ________ normal form.

Accepted Answer

The answer of If an Author field lists multiple authors...

Question 20

Which of the following is not a reason to continue to use Access for database needs?

Accepted Answer

A) Wizards 
B) Intuitive GUI 
C) Enterprise-level DBMSs are generally easier to use 
D) Access can run on a desktop 
A) Wizards 
B) Intuitive GUI 
C) Enterprise-level DBMSs are generally easier to use 
D) Access can run on a desktop

One way to bring a database into 3NF compliance is to delete all unnecessary fields.

Addressing transitive dependencies happens when you are attempting to bring your database into compliance with what normal form?

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

DBMS stands for Database ________ System.

A table with a single-field primary key is usually in compliance with what normal form?

Logical security involves the information that is found on physical devices.

Which tool creates a detailed report for each selected object?

What does ACCDE stand for?

As new tables,queries,forms,and reports are added to a database,Access actually becomes more efficient and the performance of the database increases.

The ________ Analyzer tool makes suggestions to minimizing the duplication of data.

DBMS stands for ________.

Which database tool turns your database into two files?

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

Which is not a benefit of normalization?

Including capital letters,numbers,and special characters help to make the password more secure.

What are the rules to optimize and fix potential repetition issues in a database known as?

The best way to use the Database Documenter tool is to select every option,otherwise you might miss including important data.

If an Author field lists multiple authors separated by commas like Poatsy,Rutledge,and Williams,this would be in violation of the ________ normal form.

Which of the following is not a reason to continue to use Access for database needs?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Enhanced Database Techniques

Filters

Exam 10: Fine-Tuning the Database

One way to bring a database into 3NF compliance is to delete all unnecessary fields.

Addressing transitive dependencies happens when you are attempting to bring your database into compliance with what normal form?

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

DBMS stands for Database ________ System.

A table with a single-field primary key is usually in compliance with what normal form?

Logical security involves the information that is found on physical devices.

Which tool creates a detailed report for each selected object?

What does ACCDE stand for?

As new tables,queries,forms,and reports are added to a database,Access actually becomes more efficient and the performance of the database increases.

The ________ Analyzer tool makes suggestions to minimizing the duplication of data.

DBMS stands for ________.

Which database tool turns your database into two files?

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

Which is not a benefit of normalization?

Including capital letters,numbers,and special characters help to make the password more secure.

What are the rules to optimize and fix potential repetition issues in a database known as?

The best way to use the Database Documenter tool is to select every option,otherwise you might miss including important data.

If an Author field lists multiple authors separated by commas like Poatsy,Rutledge,and Williams,this would be in violation of the ________ normal form.

Which of the following is not a reason to continue to use Access for database needs?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Enhanced Database Techniques

Filters