Tutorial

1. Which of the following statement(s) is/are true?

• [A] Primary keys can have null values

• [B] A primary key must always have a unique index

• [C] A primary key is used to relate a table to foreign keys in other tables

• [D] [A] and [B]

• [E] [B] and [C]

2. A data field validation rule

• [A] Checks the value entered into a field as the user leave the field

• [B] Checks that there is a match between data entered and a particular criterion

• [C] Produces an error message for mismatches between data entered and criterion for field

• [D] [A] and [B]

• [E] [A], [B] and [C]

3. An example of a record from the Shopping Mall database is:

• [A] Job Category

• [B] Potter

• [C] The column of data A123; A456; A777 etc

• [D] The row of data A777; Digital World; Doe; [phone]

• [E] None of the above

4. The primary key of the Store table is:

• [A] Job Category

• [B] StoreID

• [C] VacancyID

• [D] StoreName

• [E] Phone

5. An example of a foreign key in the Shopping Mall database is:

• [A] StoreID in the Vacancy table

• [B] StoreID in the Store table

• [C] VacancyID in the Vacancy table

• [D] JobCategory in the Vacancy table

• [E] None of the above

6. The field “NoofWeeks” has to contain values that are at least 1 week and no more than 10 weeks. Which would be the correct criteria for a validation rule for the “NoOfWeeks” field?

• [A] >1 and <10

• [B] >=1 and <=10

• [C] >1 and <=10

• [D] >=1 and <10

• [E] Between 0 and 11

7. The manager wishes to find all stores with temporary Security jobs available for more than 3 weeks. Which of the following would be the correct design for this query?

• 
• 
• 
• 
• 

8. When referential integrity is enforced, MS ACCESS will check that:

• [A] StoreID in the Vacancy table exists in the Store table

• [B] StoreID in Vacancy table is equal to StoreID in Store table

• [C] The related field names must be the same

• [D] [A] and [B]

• [E] [A], [B] and [C]

9. Which of the following statement(s) is/are true?

• [A] There is a one to many relationship between the Store table and the Vacancy Table

• [B] The Store table is a parent table in its relationship with the Vacancy table

• [C] There is a many to one relationship between the Store table and the Vacancy table

• [D] [A] and [B] only

• [E] [B] and [C] only