Higher Assignment - Testing & Evaluation (DDD)

Multiple Choice

A SELECT FROM query which displays the correct records but misses out a column heading is/has not...

• fit for purpose

• accurate output

Reorder

Reorder the following query testing steps

• detail expected output

• design, implement and run query

• compare expected output with actual output

• if actual output doesn't match expected return to query design

• Re-design, re-implement and re-run query

1

2

3

4

5

• 1
• 2
• 3
• 4
• 5

Open Ended

What is the purpose of the GROUP BY clause?

Open Ended

What two things are incorrect about the query results?

Open Ended

Describe one issue that may occur with a lack of validation on the fields in this table.