Transaction Processing (OCR A-Level Computer Science): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What is a transaction in database processing?
What is a transaction in database processing?
A single, indivisible unit of operations
What do the ACID properties ensure in transaction processing?
What do the ACID properties ensure in transaction processing?
Data integrity and reliability
What does atomicity guarantee in a transaction?
What does atomicity guarantee in a transaction?
Fully completes or fully fails
What does consistency ensure in transaction processing?
What does consistency ensure in transaction processing?
Database moves from one valid state to another
What does isolation mean for concurrent transactions?
What does isolation mean for concurrent transactions?
Transactions operate independently
What does durability guarantee after a transaction is committed?
What does durability guarantee after a transaction is committed?
Results are permanent, even after crashes
What is the primary purpose of record locking?
What is the primary purpose of record locking?
Prevent data being overwritten concurrently
What can a read lock (shared lock) allow?
What can a read lock (shared lock) allow?
Multiple transactions can read simultaneously
What is a deadlock in transaction processing?
What is a deadlock in transaction processing?
Two transactions waiting for each other
What is the purpose of redundancy in transaction processing?
What is the purpose of redundancy in transaction processing?
Store duplicate copies for reliability