Choose the correct answer for each question.

1. In a database of secondary school pupils, you need a field to record their primary school.
   Which validation rule would you use to make sure that they could only be from the following 3 primary schools: St Mary's, Chalford or Bisley?

   1.   ?    = St Mary's OR Chalford OR Bisley
   2.   ?    INCLUDE St Mary's OR Chalford OR Bisley
   3.   ?    = "St Mary's" AND "Chalford" AND "Bisley"
   4.   ?    ENTER "St Mary's" OR "Chalford" OR "Bisley"
   5.   ?    = "St Mary's" OR "Chalford" OR "Bisley"

2. In a database of Doctor's patients, which validation rule would limit the height field entry to between 1.3 and 2.3 metres?

   1.   ?    >= 1.3 OR <= 2.3
   2.   ?    >= 1.3 AND <= 2.3
   3.   ?    => 1.3 OR <= 2.3
   4.   ?    >= 2.3 AND <= 1.3
   5.   ?    = 1.3 OR = 2.3

3. In a database of boats, you need a field to record the price of the boat.
   The lowest price you will sell a boat for is £500 and the highest price is £5000.
   Which two possible validation rules would you create to make sure that the price entered was between these limits?

   1. >=500 AND <=5000
   2. <=500 OR >=5000
   3. >=500 OR <=5000
   4. >500 AND <5000
   5. BETWEEN 500 AND 5000
   CHECK

4. If the maximum price in a database field is to be £4000, which validation routine would allow this?
   What validation rule would be used?

   1. <=4000
   2. >=4000
   3. =4000
   4. <>4000
   5. =<4000
   CHECK

5. The length of a boat does not have to be entered, but it must be greater than or equal to 3 meters. Which validation routine would allow this?

   1. >= 3 OR IS NULL
   2. >=3
   3. => 3 OR BLANK
   4. >2.9
   5. >=3 AND IS NULL
   CHECK

6. In a database of houses, you need a field to record the number of doors.
   Which validation rule would you create to make sure that at least 2 doors were entered?

   1. >=2
   2. =>2
   3. =<2
   4. <=2
   5. >1
   CHECK

7. In a library database you do not want to allow the librarian to enter 'lost' as the location of a book.
   Which two possible validation rules would allow any other entry except the word "lost"?

   1. NOT "lost"
   2. >= "lost"
   3. <> "lost"
   4. = "lost"
   5. > "lost"
   CHECK

8. Which validation rule would only allow you to enter "Under offer" or "Sold" into a text field or leave the field blank?

   1. = "Sold" OR "Under offer" OR NULL
   2. = "Sold" AND "Under offer" OR NULL
   3. = "Sold" OR "Under offer" AND NULL
   4. = "Sold" OR "Under offer"
   CHECK