Question Constellation Sign up for free AQA · GCSE · Computer Science · Higher
SQL INSERT query completion
A relational database is being developed to store information about actors and the films they have performed in. The database contains three tables: Film, Performance and Actor.
A film called Gladiator from the year 2000 is to be added to the database with a FilmID of 103.
The following SQL is run:
Some parts of the SQL have been replaced by labels.
State the SQL that should have been written in place of the labels A, B and C.
Practice unavailable
This question can be viewed, but its original response format is not available for practice yet.
Write your answer first. You can study the marking guidance whenever you need it.
Study the marking See what earns credit and compare it with a full-mark answer.
Marking points
- 1 Replaces A with Film.
- 2 Replaces B with VALUES.
- 3 Replaces C with the correctly ordered values 103, 'Gladiator', 2000 without adding the printed parentheses.
Why this answer loses marks
I supplied the row entries in a different order from the destination fields.
Inserted entries must follow the destination field order or the data will be assigned to the wrong fields.