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

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

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

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

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

First normal form requires that ________.

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

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

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

Which normal form requires that no transitive dependencies exist?

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

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.

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

A digitally signed database requires a password to open it.

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

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

Which of the following is NOT a database security measure?

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