Skip to main content

← back to the guide

SQA Higher Administration and IT Databases overview quiz quiz

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

  1. In a database, a single column representing one piece of data (such as Surname) is called a:

  2. A primary key in a database table is a field that:

  3. A foreign key is used to:

  4. Which is an advantage of a relational database over a flat-file (single-table) one?

  5. The most common type of relationship between two linked tables is:

  6. Using AND to combine two search conditions will:

  7. Which search would return records from either the North OR the South region?

  8. A wildcard such as * in a database search is used to:

  9. A calculated field in a query or report is one whose value is:

  10. A summary total in a report is used to:

  11. What is the main purpose of a form in a database?

  12. Which of these is an advantage of using a form for data entry?

  13. A grouped report arranges records into groups by a chosen field and can show:

  14. An administrator needs the database figures in a spreadsheet to build a chart. The best approach is to:

  15. Which best describes the difference between a form and a report?