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

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

A

Question 3

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

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

Answer 3

A

Question 4

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

A) Normalization
B) Anomaly
C) Second normal form
D) Transitive dependencies

Question 5

________ provides a brief description of a potential problem and its possible solution.

A) Analysis Notes
B) Analyzer report
C) Documenter report
D) Preview report

Question 6

Which of the following can be tested by creating relationships?

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

Question 7

What are the three kinds of analysis results of the Performance Analyzer?

A) Recommendations, suggestions, and ideas
B) Recommendations, trade-offs, and ideas
C) Suggestions, trade-offs, and ideas
D) Ideas, suggestions, and solutions

Question 8

What is the best way to fix a table with repeating groups?

A) Either fix the repeating groups in Excel before importing to Access or alternately add rows in Access and separate repeating data into individual rows
B) Export table to Excel, fix repeating groups, then import back to Access
C) Create additional columns for repeating data
D) Filter or query the table searching for repeating groups

Question 9

________ are not allowed in a normalized table.

A) Repeating groups
B) Functional dependencies
C) Non-key fields
D) Composite keys

Question 10

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

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

Question 11

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

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

Question 12

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

A) transitive dependencies
B) composite keys
C) non-key fields
D) functional dependencies

Question 13

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

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

Question 14

How does Access handle multivalued fields?

A) Creates special invisible tables in the background
B) Appear as repeating groups in the table
C) Makes the multivalue field dependent on the primary key
D) Removes dependencies on required fields

Question 15

A table is in ________ if it meets 2NF criteria and no transitive dependencies exist.

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

Question 16

Which Performance Analyzer result requires manual changes?

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

Question 17

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

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

Question 18

________ creates a report that contains detailed information about the tables and other selected objects in your database.

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

Question 19

Which tool does NOT identify flaws in the design of the database?

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

Question 20

A(n) ________ occurs when the value of one field is determined by the value of another.

A) functional dependency
B) non-key field
C) composite key
D) primary key

Question 21

The ________ contains the queries, forms, and reports of the database.

A) back-end database
B) database documenter
C) front-end database
D) design tools

Question 22

________ is electronic, encryption-based, secure stamps of authentication that confirms who created the file, that the file is valid, and that no changes have been made to the file after its authentication.

A) Digital signature
B) Digital certificate
C) Package and sign
D) ACCDE

Question 23

There are three normal forms; however, the majority of database designs only require the first two normal forms.

Question 24

________ reduce the time it takes to run queries and reports.

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

Question 25

What does the Database Splitter do?

A) Splits database into two files, a back-end and a front-end database
B) Divides the table and creates relationships that control how the new tables are linked
C) Adds more indexes to increase database performance
D) Provides a brief description of a potential problem and its possible solution

Question 26

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

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

Question 27

________ is the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key.

A) Encryption
B) Open exclusive
C) Password
D) Selfcert

Question 28

What does the Table Analyzer do?

A) Analyzes the tables in a database and normalizes them for you
B) Gives you notes and specifications recommended and then fixes them
C) Provides a brief description of potential problems and possible solutions
D) Lists three kinds of analysis results

Question 29

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

A) navigation form
B) switchboard
C) command option
D) ribbon

Question 30

What database format prohibits users from making design and name changes to forms or report within the database, and prohibits users from creating new forms and reports?

A) Access Database Executable file
B) Access Database file
C) Access Database Template file
D) Database Documenter

Question 31

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

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

Question 32

What is the main reason to split an Access database?

A) Improve development and maintenance
B) To confirm the primary key of each table
C) Controls how the tables are linked
D) To decide which fields go to which tables

Question 33

One benefit of normalization is the improvement of referential integrity enforcement in relationships.

Question 34

What does a back-end database contain?

A) Tables of the database
B) Queries, forms, and reports of the database
C) Tables and queries of the database
D) Tables, forms, and reports of the database

Question 35

Minimizing data redundancy is one of the benefits of normalization.

Question 36

What is a certification authority?

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 37

Which process guarantees that you are the only one currently using the database?

A) Open exclusive
B) Encryption
C) Password protect
D) Selfcert

Question 38

What is database security?

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 39

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

A) timestamp
B) certificate
C) navigation
D) password

Question 40

________ makes the database unreadable by encrypting the database.

A) Password protect
B) Make ACCDE
C) Digital Signature
D) Encryption

Question 41

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

Question 42

The Database Documenter creates a report that contains detailed information about the tables and other selected objects in your database.

Question 43

Table Analyzer can create additional tables in your database.

Question 44

The Database Documenter saves its report in a number of formats including PDF or XPS formats.

Question 45

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

Question 46

The Performance Analyzer evaluates a database and makes recommendations for optimizing the database.

Question 47

Multivalued fields are created using the Input Mask Wizard.

Question 48

The Performance Analyzer lists three kinds of analysis results: recommendations, suggestions, and ideas.

Question 49

The Performance Analyzer Tool creates a report that contains detailed information for each selected object.

Question 50

The Database Splitter tool enables you to split a database into two files, a back-end and front-end database.

Question 51

Optimizing a database may affect the database in ways you might not consider as positive results.

Question 52

The Table Analyzer analyzes the database and normalizes it for you.

Question 53

A composite key is a primary key that is made up of one field.

Question 54

The Database Splitter tool enables you to split a database into three files: a back-end, middle, and front-end database.

Question 55

Normalization rules indicate the current state of a table.

Question 56

One reason why you may not be able to create a relationship is because there may be an issue with the way you have normalized the database.

Question 57

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

Question 58

Transitive dependencies exist in third normal forms.

Question 59

First normal form is a table that contains no repeating groups or repeating columns.

Question 60

After the Performance Analyzer lists its analysis results, Access can perform recommendations and suggestions automatically, but idea optimizations must be performed manually.

Question 61

Match the following terms with their meanings:
I. anomaly
II. composite key
III. encryption
IV. non-key field
A. the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key
B. an error or inconsistency that occurs when you add, edit, and delete data
C. a field that is not part of the primary key
D. a primary key that is made up of two or more fields

Question 62

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

Question 63

The Database Splitter is not identified by name on the Access Ribbon.

Question 64

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

Question 65

A good password should be at least eight characters which combines uppercase and lowercase letters, numbers, and symbols to make the password more difficult for others to guess.

Question 66

You cannot create an ACCDE file unless you have enabled the content in the database.

Question 67

Access 2013 incorporates encryption methods to keep databases secure.

Question 68

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

Question 69

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

Question 70

Digital certificates are electronic, encryption-based, secure stamps of authentication.

Question 71

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

Question 72

Creating an Access Database Executable (ACCDE) file will remove all VBA source code from the database.

Question 73

To set a password, the database has to be opened in exclusive mode.

Question 74

To start a navigation form automatically on start up, change settings in the Options window.

Question 75

A navigation form is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

Question 76

Match the following terms with their meanings:
I. Database Splitter
II. functional dependency
III. Table Analyzer
IV. transitive dependencies
V. Performance Analyzer
A. analyzes the tables in a database and normalizes them for you
B. evaluates a database and then makes recommendations for optimizing the database
C. occurs when the value of one non-key field is functionally dependent on the value of another non-key field
D. when the value of one field is determined by the value of another
E. enables you to split a database into two files: a back-end database, which contains the data tables, and a front-end database

Question 77

When a file is saved as an Access Database Executable file, VBA code can be executed, but it cannot be modified.

Question 78

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

Question 79

A timestamp can prove that your database has or has not been modified since you applied your signature.

Question 80

You can digitally sign and publish your database simultaneously from within Access 2013.