Deck 9: Fine-Tuning the Database: Hands-On-Exercise Videos

Question 1

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

Answer 1

D

Question 2

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

Answer 2

C

Question 3

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

Answer 3

False

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 Performance Analyzer tool to help reduce data redundancies.

Question 6

A digitally signed database requires a password to open it.

Question 7

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 8

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 9

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

Question 10

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

Question 11

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 12

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

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

Question 13

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

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

Question 14

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 15

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

Question 16

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

Question 17

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