O-LevelComputer ScienceDatabases2210/22 · May/June 2021 · Q65 Marks
6 A database table, PLANT, is used to keep a record of plants sold by a nursery. The table has these fields: • NAME – name of plant • FLOWER – whether the plant flowers (True) or not (False) • POSITION – shade, partial shade or sun • SIZE - small, medium or large • PRICE - price in $ • NUMBERSOLD – how many sold A query-by-example grid has been completed to display only the price, name and number sold of small plants that do not flower. Field: NAME Table: PLANT Sort: Show: ☑ Criteria: or: PRICE ☑ NUMBERSOLD ☑ SIZE FLOWER POSITION = "shade" Identify the errors in the query-by-example grid. Rewrite the corrected query-by-example grid. Field: Table: Sort: Show: Criteria: or:
- Identify the errors in the query-by-example grid. Rewrite the corrected query-by-example grid.[5]
This question uses a diagram from the original paper, which isn't shown here. Open the full paper from the past papers archive to see it.
Mark scheme
Marking points from the official mark scheme (May/June 2021). The mark or mark type is shown in brackets.
- [1] TABLE row not completed
- [1] POSITION column not required // POSITION criteria not required
- [1] No criteria set in the size column
- [1] No criteria set in the flower column
- [1] One mark for correct rows Field, Table and Show
- [1] One mark for correct Criteria row
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →