O-LevelComputer ScienceDatabases2210/23 · Oct/Nov 2024 · Q46 Marks

Complete the paragraph about databases. Use terms from the list. You may need to use a term more than once. Some of the terms in the list will not be used. fields comments columns constant key table primary key program records rows scripts database validation variable Database tables consist of and . Rows are . are fields. Structured query language (SQL) are used to query data. A uniquely identifies a record.

Mark scheme

Marking points from the official mark scheme (Oct/Nov 2024). The mark or mark type is shown in brackets.

One mark for each correct term
Database tables consist of rows/columns/fields/records and columns/rows/fields/records
Rows are records.
columns are fields.
Structured Query Language (SQL) scripts are used to query data.
A primary key uniquely identifies a record.

On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.

Topic: Databases, O-Level Computer Science (syllabus 2210). Structured question, 6 marks.
Source: O-Level Computer Science, Oct/Nov 2024 Paper 2 Variant 3, question 4.

Questions and mark schemes are from past examination papers and remain the copyright of the exam board. How Oracle Prep builds its content