Skip to content

Course home

Structured query language (SQL)

Structured query language (SQL)

EasyMediumHard
1234567
Question 6

An exoplanet called TOI-700 d discovered in the year 2020 is to be added to the database with a PlanetID of 105.

Exoplanet

PlanetIDPlanetNameDiscoveryYear
101Kepler-186f2014
102TRAPPIST-1e2017

Discovery

DiscoveryIDPlanetIDObservatoryID
7011019
70210212

Observatory

ObservatoryIDNameType
9Kepler Space TelescopeSpace
12La Silla ObservatoryGround

The following SQL query is run to insert this new exoplanet into the database:

INSERT INTO P
Q ( R )

Some parts of the SQL query have been replaced by the labels P, Q, and R.

State the SQL terms or values that should have been written in place of the labels P, Q, and R.

[3]
Markscheme

Structured query language (SQL) Questions

  1. GCSE
  2. /Computer Science
  3. /Structured query language (SQL)

25 exam-style questions on AQA GCSE Computer Science Structured query language (SQL). Each one has a worked solution and a mark scheme showing where the marks go.

Question bank