11 mark
The database supports ACID transactions. ACID stands for Atomicity, Consistency, Isolation and Durability.
Give one way that durability can be achieved for a completed transaction.
Did this page help you?
Databases (OCR A Level Computer Science)
Exam Questions
7 mins4 questions
21 mark
Give one disadvantage of using record locking.
Did this page help you?
32 marks
OCR Insurance uses a computer system to calculate the price that customers pay for car insurance.
Customers’ details are stored in the flat file database table Customer
Describe one problem that would arise with the flat file database structure if a customer wanted to insure more than one car at the same time.
Did this page help you?
43 marks
Explain how record locking can be used to ensure that the ACID principle of isolation is achieved when carrying out multiple transactions.
Did this page help you?