Gate Exam

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
I. 2-phase locking
II. Time-stamp ordering

option
(A) I only
(B) II only
(C) Both I and II
(D) Neither I nor II

Read Solution (Total 2)

B) coz 2 phase locking can lesd to deadlock
11 years agoHelpfull: Yes(2) No(0)

B only as in 2pl deadlock may occur
9 years agoHelpfull: Yes(0) No(0)

Gate Other Question

Consider a B+ tree in which the maximum number of keys in a node is 5. What is the minimum number of keys in any non-root node?

option
(A) 1
(B) 2
(C) 3
(D) 4 Choose the most appropriate word(s) from the options given below to complete the following sentence. I contemplated ______ Singapore for my vacation but decided against it.
(A) To visit
(B) having to visit
(C) visiting
(D)for a visit