Skip to main content

← back to the guide

SQA National 5 Computing Science Database design and development overview quiz quiz

14questions. Pick an answer and you'll see why right away.

  1. What does a primary key do in a database table?

  2. What is a foreign key?

  3. Which field type best suits storing whether a member's account is active?

  4. Which validation check makes sure a value is one of a fixed list of options?

  5. Which validation check makes sure a required field is not left empty?

  6. In SQL, which clause names the table to read from?

  7. Which SQL clause filters records so only those meeting a condition are included?

  8. What does ORDER BY ... DESC do?

  9. Which SQL statement adds a new record to a table?

  10. What happens if you run an UPDATE statement with no WHERE clause?

  11. Which statement correctly deletes only the loan with loanID 12?

  12. In SELECT name, house FROM Pupil; what is returned?

  13. Which keyword sets the new value in an UPDATE statement?

  14. After building a database, what does evaluating it for fitness for purpose check?