GATE 2006
In the Write-Ahead Logging (WAL) protocol with checkpointing, transactions that were active when a system crash occurred must be:
Related Database Management PYQs
Consider the following relational schema: • Suppliers(sid:integer, sname:string,city:string ,street:string ) • Parts(pid:integer, …
In SQL, what is the result of evaluating the predicate: NULL = NULL?
Which of the following SQL clauses is used to filter groups formed by a GROUP BY clause?
A prime attribute of a relation schema R is an attribute that:
Which relational algebra operator selects all tuples from relation R that satisfy a specified predicate P?
A transaction schedule that is conflict serializable is always guaranteed to be:
Free account benefits
Turn practice into measurable progress
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.
Saved progressKeep answers, mock results and completion history across devices.
Adaptive practiceGet questions matched to your recent accuracy and difficulty level.
Bookmarks and notesBuild a personal revision list and record why a question was difficult.
Performance insightsSee weak subjects, accuracy trends, streaks and exam readiness.