Exam 9: Fine-Tuning the Database: Analyzing and Improving Database Performance

Explore all topics

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

(Multiple Choice)

4.9/5

(35)

Question 61

A table that contains no repeating groups or repeating columns is in:

(Multiple Choice)

4.8/5

(38)

Question 62

A(n) ________ is a rule that indicates the current state of a table.

(Multiple Choice)

4.8/5

(36)

Question 63

What is database security?

(Multiple Choice)

4.7/5

(37)

Question 64

The ________ contains the queries, forms, and reports of the database.

(Multiple Choice)

4.9/5

(33)

Question 65

Digital certificates are electronic, encryption-based, secure stamps of authentication.

(True/False)

4.7/5

(39)

Question 66

What are four ways to keep your database application safe?

(Essay)

4.8/5

(26)

Question 67

What does the Database Splitter do?

(Multiple Choice)

4.9/5

(33)

Question 68

What do the Performance Analyzer Analysis Notes tell you?

(Essay)

4.7/5

(43)

Question 69

What does a back-end database contain?

(Multiple Choice)

4.9/5

(26)

Question 70

After the Performance Analyzer lists its analysis results, Access can perform recommendations and suggestions automatically, but idea optimizations must be performed manually.

(True/False)

4.8/5

(32)

Question 71

To set a password, the database has to be opened in exclusive mode.

(True/False)

4.9/5

(35)

Question 72

What are the three Performance Analyzer result types?

(Short Answer)

4.9/5

(31)

Question 73

An inconsistency in a database is referred to as a(n) ________.

(Short Answer)

4.8/5

(41)

Question 74

You cannot create an ACCDE file unless you have enabled the content in the database.

(True/False)

4.9/5

(35)

Question 75

Which Performance Analyzer result requires manual changes?

(Multiple Choice)

4.9/5

(43)

Question 76

Which tool does NOT identify flaws in the design of the database?

(Multiple Choice)

5.0/5

(26)

Question 77

What is the main reason to split an Access database?

(Multiple Choice)

4.9/5

(36)

Question 78

What are the three kinds of analysis results of the Performance Analyzer?

(Multiple Choice)

5.0/5

(48)

Question 79

The main reason to split an Access database is to improve development and maintenance.

(True/False)

4.8/5

(34)

Question 80

Showing 61 - 80 of 119

A table is in ________ if it meets 1NF criteria and all non-key fields are functionally dependent on the entire primary key.

A table that contains no repeating groups or repeating columns is in:

A(n) ________ is a rule that indicates the current state of a table.

What is database security?

The ________ contains the queries, forms, and reports of the database.

Digital certificates are electronic, encryption-based, secure stamps of authentication.

What are four ways to keep your database application safe?

What does the Database Splitter do?

What do the Performance Analyzer Analysis Notes tell you?

What does a back-end database contain?

After the Performance Analyzer lists its analysis results, Access can perform recommendations and suggestions automatically, but idea optimizations must be performed manually.

To set a password, the database has to be opened in exclusive mode.

What are the three Performance Analyzer result types?

An inconsistency in a database is referred to as a(n) ________.

You cannot create an ACCDE file unless you have enabled the content in the database.

Which Performance Analyzer result requires manual changes?

Which tool does NOT identify flaws in the design of the database?

What is the main reason to split an Access database?

What are the three kinds of analysis results of the Performance Analyzer?

The main reason to split an Access database is to improve development and maintenance.

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters