1
GATE CSE 2010
MCQ (Single Correct Answer)
+1
-0.3
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?

I. 2-phase locking
II. Time-stamp ordering

A
I only
B
II only
C
Both I and II
D
Neither I nor II
2
GATE CSE 2010
MCQ (Single Correct Answer)
+2
-0.6
Consider the following schedule for transactions T1, T2 and T3: GATE CSE 2010 Database Management System - Transactions and Concurrency Question 21 English Which one of the schedules below is the correct serialization of the above?
A
$$T1 \to T3 \to T2$$
B
$$T2 \to T1 \to T3$$
C
$$T2 \to T3 \to T1$$
D
$$T3 \to T1 \to T2$$
3
GATE CSE 2010
MCQ (Single Correct Answer)
+1
-0.3
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?
A
1
B
2
C
3
D
4
4
GATE CSE 2010
MCQ (Single Correct Answer)
+1
-0.3
$$P$$ is a $$16$$-bit signed integer. The $$2's$$ complement representtation of $$P$$ is $${\left( {F87B} \right)_{16}}$$ . The $$2's$$ complement representation of $$8{}^ * \,P$$ is
A
$${\left( {C3D8} \right)_{16}}$$
B
$${\left( {187B} \right)_{16}}$$
C
$${\left( {F878} \right)_{16}}$$
D
$${\left( {987B} \right)_{16}}$$
EXAM MAP
Medical
NEETAIIMS
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
Civil Services
UPSC Civil Service
Defence
NDA
Staff Selection Commission
SSC CGL Tier I
CBSE
Class 12