DBWebApplications 





Data Manipulation  «Prev  Next»
Matching criteria - Quiz
Each question is worth one point. Select the best answer or answers for each question.
 
1.
Record # Name Commission Date of Sale
1 Ronn $200 10/5/99
2 Ronn $650 10/2/99
3 Molinari $350 10/4/99
4 Hudson $400 10/7/99
5 Corey $600 10/11/99
6 Corey $250 10/14/99
7 Molinari $500 10/24/99
8 Hudson $600 10/27/99
9 Molinari $450 10/17/99
10 Hudson $350 10/13/99

Choose the record(s) that meet each criteria:
In the table above which records match the following criteria: Name=Hudson AND Date<10/10/99
Please select all the correct answers.
  A. 8
  B. 10
  C. 4
  D. 3


2. In the table above which records match the following criteria: Name= Corey OR Hudson AND Commision>$500
Please select all the correct answers.
  A. 4
  B. 5
  C. 8
  D. 6

3. In the table above which records match the following criteria: Commission<500 OR Date>10/10/99
Please select all the correct answers.
  A. 5
  B. 6
  C. 7
  D. 8
  E. 9
  F. 10


4. In the table above which records match the following criteria: Commission>500 AND Date>10/10/99
Please select all the correct answers.
  A. 8
  B. 9
  C. 5
  D. 10

5. Use this design grid for the question below.
Which query design matches the above design grid?
Please select the best answer.
  A. Name=Hudson AND Date<10/10/99
  B. Commission<500 OR Date>10/10/99
  C. Commission>500 AND Date>10/10/99
  D. Commission<500 AND Date<10/10/99
  E. Name= Corey OR Hudson AND Commision>$500