Deck 9: Fine-Tuning the Database

Question 1

Which of the following statements is not true about suggestions displayed by the Performance Analyzer tool?

A) They carry no risk at all.
B) They are identified by a question mark.
C) They have potential trade-offs that need to be considered.
D) They can be fixed automatically by the tool.

Answer 1

A

Question 2

Which database tool turns your database into two files?

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

Answer 2

B

Question 3

After using the Database Splitter tool, in which file are the tables located?

A) Front-end
B) Back-end
C) Table-end
D) Split-end

Answer 3

B

Question 4

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

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

Question 5

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

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

Question 6

Which of the following are typically not stored in the front-end database file?

A) Forms
B) Reports
C) Tables
D) Queries

Question 7

After using the Database Splitter tool, which file remains open?

A) Back-end
B) Front-end
C) They both remain open
D) Neither remains open

Question 8

Which tool evaluates each object in the database and suggests ways to make the database more efficient?

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

Question 9

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

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

Question 10

Which of the following statements is not true about ideas displayed by the Performance Analyzer tool?

A) They must be fixed manually.
B) They are identified by a lightbulb.
C) These changes carry the highest risk of any of the three types.
D) These often include changing data types.

Question 11

Which of the following statements is not true about recommendations displayed by the Performance Analyzer tool?

A) They are identified by an exclamation point.
B) They can be fixed automatically by the tool.
C) They carry very low risk.
D) They carry a much higher risk.

Question 12

Which tool makes suggestions to minimize the duplication of data?

A) Field Analyzer
B) Table Analyzer
C) Performance Analyzer
D) Database Analyzer

Question 13

Which tool creates a detailed report for each selected object?

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

Question 14

DBMS stands for ________.

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

Question 15

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

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

Question 16

What is not true about navigation forms?

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 17

Which of the following is not considered a tool used to analyze and improve the performance of a database?

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

Question 18

Which of the following statements is not true about indexes?

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 19

What is the most common object analyzed by the Database Documenter tool?

A) Table
B) Field
C) Report
D) Form

Question 20

Which of the following is not true about following the suggestions of the Table Analyzer tool?

A) The database will store more reliable data.
B) The database might become smaller.
C) The database will probably become larger, but more efficient.
D) Updating the database is faster because fewer changes will be required.

Question 21

What is not true about table relationships?

A) They must be set up manually.
B) They are created automatically by Access when normalization is complete.
C) Creating them can be a good test your normalization efforts.
D) Creating them allows you to retrieve data in a multi-table database.

Question 22

Which is not a benefit of normalization?

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 23

If a table contains no repeating groups or repeating columns, it is said to be in compliance with which normal form?

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

Question 24

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

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

Question 25

What is it called when the value of one non-key field is functionally dependent on the value of another non-key field?

A) Transitive dependency
B) Data Integrity violation
C) Normalization
D) Composite key violation

Question 26

Which of the following would not make a password stronger?

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 27

What is a user permitted to do when using an Access Database Executable file?

A) Modify data
B) Make changes to the forms and/or reports
C) Create new forms and/or reports
D) Modify VBA code

Question 28

Implementing the third normal form often involves creating more ________.

A) tables
B) fields
C) relationships
D) databases

Question 29

DBMS stands for Database ________ System.

Question 30

The Database ________ tool creates a detailed report for each selected object.

Question 31

What does Access use as the default tab name on a navigation form?

A) Tab 1, Tab 2, etc.
B) Page 1, Page 2, etc.
C) Name of each form or report
D) There is no default name assigned to navigation tabs.

Question 32

The most common objects analyzed by the Database Documenter tool are ________.

Question 33

When should table relationships be created?

A) As soon as tables which can be related are created
B) After completing first normal form optimization
C) After completing second normal form optimization
D) After normalization is complete

Question 34

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

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.

Question 35

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

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

Question 36

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

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

Question 37

An unnormalized form might have the designation ________.

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

Question 38

When a primary key is made up of more than one field, it is known as what type of key?

A) Foreign
B) Primary
C) Compound
D) Composite

Question 39

What does ACCDE stand for?

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

Question 40

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

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

Question 41

You should wait to create table relationships until after the ________ process is complete.

Question 42

An added benefit of a navigation form is that it can be easily converted to a(n) ________ form if the Access database is deployed on a company intranet or on the Internet.

Question 43

A(n) ________ dependency occurs when the value of one non-key field is functionally dependent on the value of another non-key field.

Question 44

A(n) ________ for a field reduces the time it takes to run queries and reports.

Question 45

ACCDE stands for Access Database ________.

Question 46

It is always a good idea to ________ your database before optimizing your database through the Performance Analyzer tool in case something goes wrong.

Question 47

Before running the Documenter, you should narrow the options so only the pertinent information is displayed.

Question 48

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

Question 49

________ is the process of efficiently organizing data so that the same data is not stored in more than one table, and that related data is stored together.

Question 50

Navigation forms are only for forms and ________.

Question 51

________ makes the data unreadable to anyone except those who possess the key password.

Question 52

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

Question 53

The Database Documenter tool becomes less important the larger the database becomes.

Question 54

The Database ________ tool divides your database into two files.

Question 55

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

Question 56

After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end.

Question 57

________ dependency occurs when the value of one field is determined by the value of another.

Question 58

A(n) ________ form is a tabbed menu system which makes the database easier to use.

Question 59

Database security can be divided into physical security and ________ security.

Question 60

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

Question 61

After using the Database Splitter tool, the tables are found in the back-end file.

Question 62

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

Question 63

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

Question 64

Often the front-end database file is stored on a server for increased security.

Question 65

Adding an index saves time searching without increasing the time it takes to add information to the database.

Question 66

Removing a password is also known as decrypting.

Question 67

Navigation forms are only for forms and/or reports, not for tables or queries.

Question 68

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

Question 69

A table is in third normal form if it meets 2NF criteria and all the fields have transitive dependencies.

Question 70

The Table Analyzer Wizard can make all the database changes by itself if that is what you desire.

Question 71

The Database Documenter tool can provide information about when a field or other object was last modified.

Question 72

If the problem is important enough, the Performance Analyzer tool will inform you of required changes that must be made to your database.

Question 73

You can easily convert ACCDE and ACCDB files back and forth from one to the other.

Question 74

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

Question 75

One purpose of using the Database Splitter tool is that you can have one front-end file and several back-end files depending on the needs of your company.

Question 76

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.

Question 77

Converting an Access database to an enterprise-level DBMS will automatically correct design issues which were present in the Access database.

Question 78

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

Question 79

If you have an address field listing the city, state, and ZIP together such as Paterson, NJ 07501, you have violated the first normal form.

Question 80

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