Database design and development - Design test questions

1

Which of the following is a definition of a presence check?

2

Which validation rule is applied when the data in a field must be one of a preset list of values?

3

What is the table shown below an example of?

Field(s) Area Name, Available, Manager

Table(s) Sports area

Criteria Available = "True"

Sort Order Area Name ASC

4

What does the shorthand ‘ASC’ stand for when used to state the sort order of a query?

5

In what scenario would a compound key be needed?

6

Which of the following tables would have a Many-to-Many relationship?