Skip to content

Course home

Programming fundamentals

Programming fundamentals

EasyMediumHard
123456789101112131415161718192021222324
Question 11

Telemetry logs for a fleet of atmospheric research drones are stored in a database table called TblDroneTelemetry.

The following SQL statement is written to select all columns for telemetry records where the recorded altitude in metres (AltitudeMtrs) is strictly greater than 120.

SELECT ALL
FROM TblDroneTelemetry
IF AltitudeMtrs <= 120

The SQL statement is incorrect.

Rewrite the SQL statement so that it is correct.

[4]
Markscheme

Programming fundamentals Questions

  1. GCSE
  2. /Computer Science
  3. /Programming fundamentals

95 exam-style questions on OCR GCSE Computer Science Programming fundamentals. Each one has a worked solution and a mark scheme showing where the marks go.

Question bank