Programming fundamentals
34
0/4

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]

Programming fundamentals Questions

Practise OCR GCSE Computer Science Programming fundamentals with exam-style questions for GCSE Computer Science. 100 questions, matched to the OCR GCSE Computer Science (J277) specification and written in Component 01 and Component 02 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.

PreviousNext

Programming fundamentals Questions

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