GATE 2016 · CS1 - Forenoon
A 2PL protocol acquires exclusive locks to objects O1, ..., Ok in increasing order of their addresses, performs operations, and releases all locks at the end. This protocol will
Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY?
Which one of the following is NOT a part of the ACID properties of database transactions?
Schema R(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) with PK (VOLUME, NUMBER, STARTPAGE, ENDPAGE). FDs: (VOLUME, NUMBE…
B+ Trees are considered BALANCED because
Construct the precedence graph of schedule S with vertices representing transactions and edges representing conflicts. If S is ser…
Schedule S: r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X); a1; a2. Which statement is TRUE?
Free account benefits
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.