Practice IB Computer Science (First Exam 2027) Topic A3.3 Database Programming with authentic exam-style questions for both SL and HL students. This question bank focuses on the exact syllabus content for A3.3 Database Programming and mirrors Paper 1, 2 style where relevant.
Get instant solutions, detailed explanations, and build confidence with questions aligned to IB examiner expectations.
A junior developer writes a statement intended to correct one customer's address, but omits the WHERE clause. the consequences and how the damage could have been contained.
A school database contains two tables:
STUDENT(StudentID, Name, FormGroup)
RESULT(ResultID, StudentID, TestDate, Mark)
Each student can have many results.
an SQL query to list the names of students who scored more than 80, with no name appearing twice.
A payment system groups a debit and a credit into one unit of work. the three transaction control language commands used to manage a transaction.
A customer transfers 500 between two accounts held at the same bank. how the four ACID properties together guarantee reliable processing of a bank transfer.
A materialized view of monthly sales figures is refreshed once each night. one advantage and one limitation of this arrangement.
