Exam 10: Fine-Tuning the Database

Removing a password is also known as decrypting.

By definition, a table cannot be in 1NF unless it is already in 2NF, and it cannot be in 3NF unless it is in 2NF.

A table is in third normal form if it meets 2NF criteria and all the fields have transitive dependencies.

After using the Database Splitter tool, in which file are the tables located?

Which of the following statements is not true about indexes?

One way to bring a database into 3NF compliance is to delete all unnecessary fields.

Which of the following statements is not true about suggestions displayed by the Performance Analyzer tool?

Match the following Database Documenter Options with their descriptions: I. Include for table: permissions by User and Group II. Include for Fields: Names, Data types, and Sizes III. Include for Fields: Names, Data types, Sizes, and properties IV. Include for Indexes: Names, Fields, and properties V. Include for table: properties A. Includes field names, data types, and field sizes for each field in the selected tables B. Includes field names, data type, and field size for each field in the selected tables and options such as whether a zero-length value (or null value) is allowed, column width, and text alignment C. Shows permissions for the tables based on users and/or groups D. Documents table properties, including number of records, date of last update, and formatting E. Includes the names of all indexes, the fields with which they are associated with, and the index properties, including the number of distinct index values and whether the index is required and must be unique

The Performance Analyzer tool has become so sophisticated that it will catch performance issues in the database.

If an Address field lists the city, state, and ZIP together, it would be in violation of the ________ normal form.

Addressing transitive dependencies happens when you are attempting to bring your database into compliance with what normal form?

Adding a password and encryption to a database requires the database to be opened in ________ mode.

Creating relationships is not an effective way to test your normalization.

What are the rules to optimize and fix potential repetition issues in a database known as?

Which of the following is not a type of analysis result given by the Performance Analyzer tool?

The Database ________ can allow you to view details that are not necessarily apparent by looking at an object.

Which tool creates a detailed report for each selected object?

A table with a single-field primary key is usually in compliance with what normal form?

What does Access use as the default tab name on a navigation form?

Match the following tool or feature with how it might be used: I. Table Analyzer II. Performance Analyzer III. Database Documenter IV. Encryption V. Normalization A. Process of efficiently organizing data B. Adding a password to a table C. Report of detailed information about selected objects D. Makes recommendations for optimizing a database E. Can automatically normalize the tables in a database