NEW
New Website Launch
Experience the best way to solve previous year questions with mock tests (very detailed analysis), bookmark your favourite questions, practice etc...
VISIT NOW

GATE CSE

Transactions and Concurrency

Database Management System

Previous Years Questions

Marks 1

More
Let Ri(z) and Wi(z) denote reac and write operations on a data element z by a transaction Ti, respectively. Consider the...
GATE CSE 2022
Consider the following two statements about database transaction schedules: I. Strict two-phase locking protocol genera...
GATE CSE 2019
Suppose a database schedule $$S$$ involves transactions $${T_1},\,...,\,{T_n}.$$ Construct the precedence graph of $$S$$...
GATE CSE 2016 Set 2
Which one of the following is NOT a part of the $$ACID$$ properties of database transactions?
GATE CSE 2016 Set 1
Consider the following transaction involving two bank accounts x and y. read (x) ; x: = x - 50; write (x); read (y); y:...
GATE CSE 2015 Set 2
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I....
GATE CSE 2010
Amongst the ACID properties of a transaction, the 'Durability' property requires that the changes made to the database b...
GATE CSE 2005
Which level of locking provides the highest degree of concurrency in a relational database?
GATE CSE 2004
Which of the following scenarios may lead to an irrecoverable error in a database system?
GATE CSE 2003

Marks 2

More
Let ri(z) and wi(z) denote read and write operations respectively on a data item z by a transaction Ti. Consider the fol...
GATE CSE 2021 Set 1
Suppose a database system crashes again while recovering from a previous crash. Assume checkpointing is not done by the ...
GATE CSE 2021 Set 1
Consider a schedule of transactions T1 and T2 : Here, RX stands for “Read(X)” and WX stands for “Write(X)”. Which one o...
GATE CSE 2020
Consider the following database schedule with two transactions, T1 and T2 S = r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X)...
GATE CSE 2016 Set 2
Consider the following two phase locking protocol. Suppose a transaction $$T$$ accesses (for read or write operations), ...
GATE CSE 2016 Set 1
Consider the following partial Schedule S involving two transactions $$T1$$ and $$T2.$$ Only the read and the write oper...
GATE CSE 2015 Set 3
Consider a simple checkpointing protocol and the following set of operations in the log. (start, $$T4$$); (write, $$T4,...
GATE CSE 2015 Set 2
Consider the following schedule S of transactions T1, T2, T3, T4: ...
GATE CSE 2014 Set 2
Consider the transactions T1, T2, and T3 and the schedules S1 and S2 given below. T1 : r1 (X) ; r1 (Z) ; w1 (X) ; w1 (Z)...
GATE CSE 2014 Set 3
Consider the following four schedules due to three transactions (indicated by the subscript) using read and write on a d...
GATE CSE 2014 Set 1
Consider the following transactions with data items P and Q initialized to zero: T1 : read (P) ; read (Q) ; ...
GATE CSE 2012
Consider the following schedule for transactions T1, T2 and T3: Which one of the schedules below is the correct seriali...
GATE CSE 2010
Let R and S be relational schemes such that R = { a, b, c } and S = { c }. Now consider the following queries on the dat...
GATE CSE 2009
Consider two transactions T1 and T2 and four schedules S1, S2, S3, S4 of T1 and T2 as given below: T1: R1[ x ] W1[ x ] ...
GATE CSE 2009
Consider the following three schedules of transactions T1, T2 and T3. [ Notation: In the following NYO represents the ac...
GATE CSE 2008
Consider the following two transactions: T1 and T2. T1: read (A); T2: read (B); read (B); ...
GATE CSE 2007
Consider the following schedules involving two transactions. Which one of the following statements is TRUE? S1: r1(X); ...
GATE CSE 2007
Consider the following schedule S of transactions T1 and T2: Which of the following is TRUE about the schedule S?...
GATE CSE 2004
Consider three data items D1, D2, and D3, and the following execution schedule of transactions T1, T2, and T3. In the di...
GATE CSE 2003
For the schedule given below, which of the following is correct: ...
GATE CSE 1999

Joint Entrance Examination

JEE Main JEE Advanced WB JEE

Graduate Aptitude Test in Engineering

GATE CSE GATE ECE GATE EE GATE ME GATE CE GATE PI GATE IN

Medical

NEET

CBSE

Class 12