Skip to content

Course home

Programming fundamentals

Programming fundamentals

EasyMediumHard
123456789101112131415161718192021222324
Question 6

A marine biology research institute stores telemetry data from tagged ocean wildlife.

The database table TblMarineTag contains records of active and historical animal tracking tags.

TagIDSpeciesStatusDepthLimit
TG-402Blue WhaleActive500
TG-109Green TurtleInactive80
TG-881HammerheadActive300
TG-304Manta RayActive120

Complete the SQL statement to show the TagID and DepthLimit of all tags that have a Status of 'Active'.

SELECT TagID, .....

FROM .....

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