Exam 9: Fine-Tuning the Database

You should wait until the normalization process is complete before creating relationships between tables.

Which of the following would not make a password stronger?

Which of the following is not considered to be an enterprise-level DBMS?

________ is the process of efficiently organizing data so that the same data is not stored in more than one table, and that related data is stored together.

ACCDE stands for Access Database ________.

Which of the following are typically not stored in the front-end database file?

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

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

What is a user permitted to do when using an Access Database Executable file?

The Database Documenter tool becomes less important the larger the database becomes.

As new tables, queries, forms, and reports are added to a database, Access actually becomes more efficient and the performance of the database increases.

After using the Database Splitter tool, the tables are found in the back-end file.

What is not true about navigation forms?

Which of the following is not a reason to continue to use Access for database needs?

It is always a good idea to ________ your database before optimizing your database through the Performance Analyzer tool in case something goes wrong.

DBMS stands for Database ________ System.

The Database Documenter tool can provide information about when a field or other object was last modified.

If a table contains no repeating groups or repeating columns, it is said to be in compliance with which normal form?

The Database ________ tool creates a detailed report for each selected object.

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