Databases
9What the syllabus asks of you
- Define a single-table database from given data storage requirements
- Suggest suitable basic data types
- Understand the purpose of a primary key and identify a suitable primary key for a given database table
- Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table
Read the notes first
Chapter 9: Databases
Drill this topic
All 41 questions on Databases, untimed — answer on paper, then mark yourself against the mark scheme.
Make a worksheet
Choose the years and how many questions, then print it with the answers on separate pages.
41 questions
These are structured questions, answered in working rather than by picking an option, so they are not listed here one by one. The drill above puts each in front of you with its mark scheme to check against.