Databases
9What the syllabus asks of you
- Define a single-table database from given data • Including: storage requirements – fields – records – validation
- Suggest suitable basic data types • Including: – text/alphanumeric – character – Boolean – integer – real – date/time
- Understand the purpose of a primary key and identify a suitable primary key for a given database table
- Read, understand and complete structured • Limited to: query language (SQL) scripts to query data stored in a single database table – – SELECT FROM – WHERE – ORDER BY DESCENDING – ORDER BY ASCENDING – SUM – COUNT – AND – OR • Identifying the output given by an SQL statement that will query the given contents of a database table
Read the notes first
Chapter 9: Databases
Drill this topic
All 22 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.
22 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.