O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12 Transaction Processing and Concurrency Control

State True/False

1.True
2.True
3.True
4.True
5.True
6.True
7.False
8.True
9.True
10.True
11.True
12.True
13.True
14.False
15.True
16.True
17.True
18.True
19.True
20.True
21.True
22.True
23.True
24.True
25.True
26.True
27.True
28.True
29.True
30.True
31.True
32.True.

 

Tick (✓) the Appropriate Answer

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

 

Fill in the Blanks

1.Logical unit
2.Concurrency control
3.Wait-for-graph.
4.Read, Write
5.Concurrency control
6.All actions associated, none
7.(a) Atomicity, (b) Consistency, (c) Isolation, (d) Durability
8.Isolation
9.Transaction recovery subsystem
10.Record, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required