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

Computers and Technology

Genesis Holland

14 July, 00:50

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.

+5

Answers (1)

Know the Answer?

Stacy · 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.