Computer Science · Oct / Nov 2023 · Paper 2 SL · Question 2
Adapt for 2027Transactions (A3.3.6, HL only) and concurrency control are covered, but validation versus verification and database recovery are not named in the syllabus. Includes Higher Level only content, which Standard Level students do not study.
IBCS
As printed in the paper
The question as text
2. The restaurant owner has hired a database administrator to extend the database. The database administrator has decided to delete the LinePrice field from the ORDERLINE table. ORDERLINE OrderID ItemID Quantity UnitPrice LinePrice DM1007 F1234 1 16.99 16.99 DM1007 W2134 2 6.99 13.98
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
2(a)[3]
2(b)[1]
2(c)(i)[1]
2(c)(ii)[2]
2(d)[4]
2(e)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.