Deck 38: Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Question 1

________ 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

Answer 1

A

Question 2

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.

Answer 2

A

Question 3

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 3

A

Question 4

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 5

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 6

Which Performance Analyzer result requires manual changes?

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

Question 7

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

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 9

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

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

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

Question 11

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

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

Question 12

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 13

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

________ are not allowed in a normalized table.

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

Question 17

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 18

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

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

Question 19

Which of the following can be tested by creating relationships?

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

Question 20

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 21

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 22

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 23

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

Question 24

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

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

Question 25

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 26

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

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

Question 27

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 28

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

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

Question 29

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 30

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

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 33

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 34

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

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

Question 36

________ makes the database unreadable by encrypting the database.

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

Question 37

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

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

Question 38

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 39

Minimizing data redundancy is one of the benefits of normalization.

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

Normalization rules indicate the current state of a table.

Question 45

Transitive dependencies exist in third normal forms.

Question 46

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

Question 47

Table Analyzer can create additional tables in your database.

Question 48

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

Question 49

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

Question 50

Multivalued fields are created using the Input Mask Wizard.

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

Access 2013 incorporates encryption methods to keep databases secure.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

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

________ mode guarantees that you are the only one currently using the database.

Question 80

A(n)________ database contains only the tables of a database.