Answer True or False to these questions
a. Schedules under strict 2PL do not allow dirty reads.
b. Every serializable schedule is conflict serializable.
c. An index containing ‘data records’ in ‘data entries’ can be unclustered.
d. Using an unclustered index speedups range search.
e. If all operations of transactions are read-only, then every schedule is serializable.
f. 2PL allow deadlocks and strict 2PL avoids deadlocks.
g. Only one transaction can hold a shared lock at any time.

Question

contestada

Respuesta :

Lanuel Lanuel · Answer 1 · 2020-06-03T04:19:55+02:00

Answer:

a. True: Schedules under strict 2PL do not allow dirty reads.

b. False: Every serializable schedule is conflict serializable.

c. False: An index containing ‘data records’ in ‘data entries’ can be unclustered.

d. False: Using an unclustered index speedups range search.

e. True: If all operations of transactions are read-only, then every schedule is serializable.

f. False: 2PL allow deadlocks and strict 2PL avoids deadlocks.

g. False: Only one transaction can hold a shared lock at any time.