Deck 35: Fine Tuning the Database: Analyzing and Improving Database Performance

Question 1

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

Answer 1

A

Question 2

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

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

Answer 2

A

Question 3

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

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

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

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 7

Which of the following can be tested by creating relationships?

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

Question 8

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

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

Question 9

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

________ are not allowed in a normalized table.

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

Question 11

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

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 13

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 14

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 15

Which Performance Analyzer result requires manual changes?

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

Question 16

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 17

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 18

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

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 20

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 21

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 22

Minimizing data redundancy is one of the benefits of normalization.

Question 23

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 24

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 25

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

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

Question 26

________ makes the database unreadable by encrypting the database.

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

Question 27

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 28

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

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

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

Question 30

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

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

Question 31

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

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

Question 33

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 34

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

Question 35

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 36

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 37

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

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

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

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

Normalization rules indicate the current state of a table.

Question 49

Table Analyzer can create additional tables in your database.

Question 50

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

Question 51

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

Question 52

Multivalued fields are created using the Input Mask Wizard.

Question 53

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

Question 54

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

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

Transitive dependencies exist in third normal forms.

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

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 certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Question 65

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

Question 66

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

Question 67

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

Question 68

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 69

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

Question 70

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

Question 71

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

Question 73

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

Question 74

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

Question 75

Access 2013 incorporates encryption methods to keep databases secure.

Question 76

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 77

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

Question 79

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

Question 80

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