07 - OLTP Logging Flashcards by Felix Grimm

Q

STEAL policy

A

Dirty Page in buffer pool can be evicted

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

NO-STEAL policy

A

Dirty Page in buffer pool can not be evicted

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

FORCE policy

A

Write-back do disk is required before commit

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

NO-FORCE policy

A

Write back to disk is not required before commit

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

NoSteal NoForce operations during recovery

A

Redo + No Undo

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Steal NoForce operations during recovery

A

Redo + Undo

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

NoSteal Force operations during recovery

A

No Redo + No Undo

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Steal + Force operations during recovery

A

No Redo + Undo

How well did you know this?

1

Not at all

2

3

4

5

Perfectly