DBWebApplications 





Refining Access Queries  «Prev  Next»

Optimizing queries with indexes - Quiz


Working with query field properties and optimizing queries with indexes


Each question is worth one point. Select the best answer or answers for each question.
 
1. Which property is not a query field property?
Please select the best answer.
  A. Format
  B. Validation Rule
  C. Caption
  D. Input Mask


2. To improve query performance, you would place an index on which two fields?
Please select all the correct answers.
  A. Fields that cannot be used in criteria
  B. Sorted fields
  C. Fields used in calculated expressions
  D. Joined fields

3. When you have more than one criteria in a query, you will get the best performance by taking which action?
Please select the best answer.
  A. Creating separate indexes for each field used
  B. Creating a composite index for all the fields used in the criteria
  C. Not creating any indexes
  D. Creating an index for only one of the fields used in the criteria