GATE 2007
Which relational algebra operation combines all tuples from two relations that have matching values in common attributes, plus retains unmatched tuples from the left relation filled with NULLs?
Related Database Management PYQs
The ACID property that guarantees that all updates performed by a committed transaction survive system crashes and power failures …
A primary index is created on a database file when the file is ordered on:
Which of the following relational calculus languages is based on first-order predicate logic with variables ranging over individua…
A relation R is in BCNF if for every functional dependency X -> Y:
The lost update problem in database concurrency control is caused primarily by:
A schedule in which each transaction reads only changes committed by earlier transactions is called:
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.