Deck 36: Fine Tuning the Database: Hands On Exercise Videos

Question 1

You would use the Performance Analyzer tool to help reduce data redundancies.

Answer 1

False

Question 2

To make the opening of forms and reports easy for users,you could implement a(n)________ form,which is a menu system that uses tabs.

A)navigation
B)tabbed
C)linked
D)active

Answer 2

A

Question 3

Which of the following is NOT a result of running the Performance Analyzer tool?

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

Answer 3

B

Question 4

Which normal form requires that all non-key fields are functionally dependent on the entire primary key?

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

Question 5

You would use the ________ to evaluate a database and produce results for optimizing the database.

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

Question 6

Which of the following tools is used to create a report that details information on relationships between tables?

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

Question 7

Relationships are created in the relationships window by dragging a field from one table to a field in another table.

Question 8

Which normal form requires that no transitive dependencies exist?

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

Question 9

To prevent users from making changes to a database,you can save it as a(n)________ file.

A)PDF
B)ACCDE
C)RTF
D)ACCDB

Question 10

A digitally signed database requires a password to open it.

Question 11

If you lose the password of an encrypted database,you can contact Microsoft to unlock the database.

Question 12

First normal form requires that ________.

A)all non-key fields in your tables are functionally dependent on the primary keys
B)all foreign keys are independent from the primary keys
C)your tables have no transitive dependencies
D)your tables contain no repeating groups or columns.

Question 13

A field that has multiple values separated by commas is an example of a repeating group.

Question 14

A primary key that consists of more than a single field is called a ________ key.

A)merged
B)compound
C)composite
D)combined

Question 15

When you use the Database Splitter tool,it splits a database into two files:
________.

A)major and minor
B)primary and secondary
C)independent and dependent
D)front-end and back-end

Question 16

Which of the following is NOT a database security measure?

A)Encrypt and password-protect a database
B)Save the database as an ACCDE file
C)Distribute the database as a PDF file
D)Digitally sign and publish a database

Question 17

You should consider using the Database Splitter tool to see if the performance of a database can be improved.