Section 11 Chapter 65 - Defining and Updating Tables Using SQL Flashcards
1
Q
Client server database
A
Provides access to the database for multiple clients simultaenously
2
Q
How concurrent access can be controlled (4)
A
- Record locks
- Serialisation
- Timestamp ordering
- Commitment ordering
3
Q
Record locks
A
Prevent simultaenous access to records
4
Q
Serialisation
A
Forces them to not overlap
5
Q
Timestamp ordering
A
Transactions are given timestamps and the earlier one is applied first