Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Computer Science AQA A2 > Section 11 Chapter 65 - Defining and Updating Tables Using SQL > Flashcards

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How concurrent access can be controlled (4)

A
  • Record locks
  • Serialisation
  • Timestamp ordering
  • Commitment ordering
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Record locks

A

Prevent simultaenous access to records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Serialisation

A

Forces them to not overlap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Timestamp ordering

A

Transactions are given timestamps and the earlier one is applied first

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

Computer Science AQA A2 (37 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions