Skip to content

Course home

Programming fundamentals

Programming fundamentals

EasyMediumHard
123456789101112131415161718192021222324
Question 15

Inventory records for a bicycle shop are stored in a database table called TblBicycles.

The following SQL statement is written to select all columns for bicycle records where the quantity in stock (InStock) is less than 3.

SELECT ALL
FROM TblBicycles
IF InStock >= 3

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