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

Rover

Computers & Technology

23 January, 00:59

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.

+2

Answers (1)

Know the Answer?

Jerome · Answer 1

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.