Question 1

What is not true about opening a database in exclusive mode?

Accepted Answer

A) It ensures that you are the only one using the database at the moment. 
B) It is the default mode when opening a database. 
C) It must be used to add a password to a database. 
D) It must be used to add encryption to a database. 
A) It ensures that you are the only one using the database at the moment. 
B) It is the default mode when opening a database. 
C) It must be used to add a password to a database. 
D) It must be used to add encryption to a database. B

Question 2

The goal in proper database design is to be able to qualify for third normal form,then second normal form,then first normal form,then zero normal form.

Accepted Answer

A) True 
 B)False  False

Question 3

The ________ Analyzer tool evaluates each object in the database and suggests ways to make the database more efficient.

Accepted Answer

Performance

Question 4

Match between columns
                        Premises: Index
Composite key
ACCDE
Anomaly
Non-key field

Accepted Answer

The Answer of Speeds up searches and A primary key is...

Question 5

What is not true about navigation forms?

Accepted Answer

A) Objects can be hidden from the user's view. 
B) It uses a menu interface. 
C) It allows a user to move easily from one object to another. 
D) It is the most useful for technical people,as opposed to nontechnical people. 
A) Objects can be hidden from the user's view. 
B) It uses a menu interface. 
C) It allows a user to move easily from one object to another. 
D) It is the most useful for technical people,as opposed to nontechnical people.

Question 6

Match between columns
                        Premises: Navigation form
Table Analyzer
Database Documenter
Functional dependency
Performance Analyzer

Accepted Answer

The Answer of Tabbed menu making the database easier to is...

Question 7

Which of the following statements is not true about indexes?

Accepted Answer

A) They should be added to every field. 
B) They should be added to fields which are searched or sorted often. 
C) They improve performance. 
D) They are commonly suggested by the Performance Analyzer tool. 
A) They should be added to every field. 
B) They should be added to fields which are searched or sorted often. 
C) They improve performance. 
D) They are commonly suggested by the Performance Analyzer tool.

Question 8

Which of the following would not make a password stronger?

Accepted Answer

A) Use your anniversary date. 
B) Make it longer. 
C) Use upper and lower case letters. 
D) Use words not found in the dictionary. 
A) Use your anniversary date. 
B) Make it longer. 
C) Use upper and lower case letters. 
D) Use words not found in the dictionary.

Question 9

Match between columns
                        Premises: Encryption
Transitive dependency
Anomaly
Access Database Executable
Non-key field

Accepted Answer

The Answer of When the value of one non-key field is...

Question 10

ACCDE stands for Access Database ________.

Accepted Answer

The answer of ACCDE stands for Access Database ________....

Question 11

Adding a password and encryption to a database requires the database to be opened in ________ mode.

Accepted Answer

The answer of Adding a password and encryption to a...

Question 12

Unfortunately,to bring all your tables into Normalization often involves data loss.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: Include for table: properties
Include for table: relationships
Include for Fields: Nothing
Include for Indexes: Nothing
Include for Indexes: Names and Fields

Accepted Answer

The Answer of Includes no detail about the indexes in is...

Question 14

If you have two values in one field,which normal form have you violated?

Accepted Answer

A) 0NF 
B) 1NF 
C) 2NF 
D) 3NF 
A) 0NF 
B) 1NF 
C) 2NF 
D) 3NF

Question 15

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

Accepted Answer

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

Question 16

Match between columns
                        Premises: Front-end database
Composite key
Database Splitter
Back-end database
Index

Accepted Answer

The Answer of Contains the tables and Contains the forms,reports,and is...

Question 17

The Database ________ tool divides your database into two files.

Accepted Answer

The answer of The Database ________ tool divides your database...

Question 18

Which of the following is not considered to be an enterprise-level DBMS?

Accepted Answer

A) Oracle 
B) Access 
C) MySQL 
D) Microsoft SQL Server 
A) Oracle 
B) Access 
C) MySQL 
D) Microsoft SQL Server

Question 19

Which of the following is not a reason to split a database?

Accepted Answer

A) Increased efficiency with a limited number of users 
B) Increased security 
C) Increased flexibility 
D) Increased reliability 
A) Increased efficiency with a limited number of users 
B) Increased security 
C) Increased flexibility 
D) Increased reliability

Question 20

An unnormalized form might have the designation ________.

Accepted Answer

A) 3NF 
B) 2NF 
C) 1NF 
D) 0NF 
A) 3NF 
B) 2NF 
C) 1NF 
D) 0NF

What is not true about opening a database in exclusive mode?

The goal in proper database design is to be able to qualify for third normal form,then second normal form,then first normal form,then zero normal form.

The ________ Analyzer tool evaluates each object in the database and suggests ways to make the database more efficient.

What is not true about navigation forms?

Which of the following statements is not true about indexes?

Which of the following would not make a password stronger?

ACCDE stands for Access Database ________.

Adding a password and encryption to a database requires the database to be opened in ________ mode.

Unfortunately,to bring all your tables into Normalization often involves data loss.

If you have two values in one field,which normal form have you violated?

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

The Database ________ tool divides your database into two files.

Which of the following is not considered to be an enterprise-level DBMS?

Which of the following is not a reason to split a database?

An unnormalized form might have the designation ________.

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

What is not true about opening a database in exclusive mode?

The goal in proper database design is to be able to qualify for third normal form,then second normal form,then first normal form,then zero normal form.

The ________ Analyzer tool evaluates each object in the database and suggests ways to make the database more efficient.

What is not true about navigation forms?

Which of the following statements is not true about indexes?

Which of the following would not make a password stronger?

ACCDE stands for Access Database ________.

Adding a password and encryption to a database requires the database to be opened in ________ mode.

Unfortunately,to bring all your tables into Normalization often involves data loss.

If you have two values in one field,which normal form have you violated?

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

The Database ________ tool divides your database into two files.

Which of the following is not considered to be an enterprise-level DBMS?

Which of the following is not a reason to split a database?

An unnormalized form might have the designation ________.

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