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

Question 1

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

Answer 1

A

Question 2

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

Answer 2

A

Question 3

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

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

Which Performance Analyzer result requires manual changes?

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

Question 6

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 7

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

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

Question 8

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

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

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

Question 10

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 11

________ are not allowed in a normalized table.

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

Question 12

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

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

Which of the following can be tested by creating relationships?

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

Question 15

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 16

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

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

Question 17

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 18

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 19

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

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

Minimizing data redundancy is one of the benefits of normalization.

Question 23

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

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

Question 24

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

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 27

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

Question 28

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

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

Question 29

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

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

Question 30

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 31

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

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 33

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

Question 34

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 35

________ makes the database unreadable by encrypting the database.

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

Question 36

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

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

Question 37

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

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 40

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 41

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

Question 42

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

Question 43

Normalization rules indicate the current state of a table.

Question 44

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

Question 45

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

Question 46

Table Analyzer can create additional tables in your database.

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

Multivalued fields are created using the Input Mask Wizard.

Question 55

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

Question 56

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

Question 57

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 58

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

Question 59

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

Question 60

Transitive dependencies exist in third normal forms.

Question 61

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

Question 62

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

Question 63

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

Question 64

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 65

Access 2013 incorporates encryption methods to keep databases secure.

Question 66

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

Question 67

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

Question 68

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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 79

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

Question 80

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