Database Systems: Concepts, Design and Applications

Chapter 13 Database Recovery Systems

State True/False

1.	True
2.	True
3.	True
4.	True
5.	True
6.	True
7.	True
8.	True
9.	True
10.	True
11.	True
12.	False
13.	True
14.	True
15.	True
16.	True
17.	False
18.	True
19.	True
20.	True.

 

Tick (✓) the Appropriate Answer

1.	(c)
2.	(c)
3.	(b)
4.	(a)
5.	(b) and (c)
6.	(a)
7.	(c)
8.	(c)
9.	(d)
10.	(d)
11.	(d)
12.	(c)
13.	(a)
14.	(a)
15.	(a)
16.	(b)
17.	(a)
18.	(a)
19.	(a)
20.	(a)
21.	(d)
22.	(a)
23.	(d)

 

Fill in the Blanks

1.	Database recovery
2.	Rollback
3.	Global undo
4.	Force approach, force writing
5.	No force approach
6.	A single-user
7.	NO-UNDO/NO-REDO
8.	Transaction management
9.	(a) data inconsistencies, (b) data loss
10.	(a) hardware failure, (b) software failure, (c) media failure, (d) network failure
11.	Inconsistent state, consistent
12.	(a) different building, (b) protected against danger
13. ...