Time Left - 10:00 mins

IIIT Hyderabad Practice Quiz : Databases-3

Attempt now to get your rank among 213 students!

Question 1

Consider the following locking protocol:
I. Transaction must lock all data items before begins any read or write operation.
II. Transaction executes all read and write operations along with transaction commit.
III. Transaction unlocks all data items.
Which of the following is true about given protocol?

Question 2

Consider the following schedule S on 4 transactions i.e. T1, T2, T3 and T4 which are working on two data items namely A and B:

S: R4(A), R2(A), R3(A), W1(B), W2(A), R3(B), W2(B)

Which of the following is correct?

Question 3

Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

Question 4

Why do we need concurrency control on B+ trees ?

Question 5

A dense index containing 1024 entries can be converted to sparse index with 8 entries by-
  • 213 attempts
  • 1 upvote

Posted by:

Priya UpadhyayPriya UpadhyayMember since Sep 2020
Priya Upadhyay
Share this quiz   |