NEW
Font size
WorksheetsTutorial
Total questions: 9
Worksheet time: 7mins
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; (039)-145-2341
[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
