Back to marketplace
Section 11 Chapter 65 - Defining and Updating Tables Using SQL
No description yet. This curated deck is ready for daily study.
Total cards: 5•Content version: v4•Public deck•Updated: 8/1/2026
Card preview (5)
#1
Front (Question)
Client server database
Back (Answer)
Provides access to the database for multiple clients simultaenously
#2
Front (Question)
How concurrent access can be controlled (4)
Back (Answer)
• Record locks • Serialisation • Timestamp ordering • Commitment ordering
#3
Front (Question)
Record locks
Back (Answer)
Prevent simultaenous access to records
#4
Front (Question)
Serialisation
Back (Answer)
Forces them to not overlap
#5
Front (Question)
Timestamp ordering
Back (Answer)
Transactions are given timestamps and the earlier one is applied first