Database programming

A3.3

What the syllabus asks of you

A3.3.1 Outline the differences between data language types within SQL.
A3.3.2 Construct queries between two tables in SQL.
A3.3.3 Explain how SQL can be used to update data in a database.
A3.3.4 Construct calculations within a database using SQL’s aggregate functions. (HL only)
A3.3.5 Describe different database views. (HL only)
A3.3.6 Describe how transactions maintain data integrity in a database. (HL only)

I'm studying

Drill this topic

Every question on Database programming that your level can use, untimed — answer on paper, then mark yourself against the mark scheme.

Start drill →

Make a worksheet

Choose the years and how many questions, then print it with the answers on separate pages.

Make a worksheet →

303737 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.