Podcast
Questions and Answers
Which technique is used to prevent simultaneous access to objects in a database?
Which technique is used to prevent simultaneous access to objects in a database?
- Record locking (correct)
- Serialisation
- Timestamp ordering
- Deadlocks
What can happen if two users are attempting to update two records simultaneously?
What can happen if two users are attempting to update two records simultaneously?
- Timestamp ordering
- Record locks
- Data inconsistencies (correct)
- Serialisation
What is a situation called when two users are unable to proceed with their updates?
What is a situation called when two users are unable to proceed with their updates?
- Deadlock (correct)
- Timestamp ordering
- Serialisation
- Record locking
Which technique ensures that transactions do not overlap in time?
Which technique ensures that transactions do not overlap in time?
What must the DBMS do when a deadlock occurs?
What must the DBMS do when a deadlock occurs?
Flashcards are hidden until you start studying