Concurrency Flashcards by Tom B

Q

Lost update

A

Two transactions overwrite each others changes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Uncommitted update (Dirty read)

A

One transaction reads data written by another that hasn’t been committed

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Strict Two-Phase Locking (Strict 2PL)

A

Dirty reads and cascading aborts, prevents both

How well did you know this?

1

Not at all

2

3

4

5

Perfectly