GATE 2005
In relational database design, transitive dependency of a non-prime attribute on a candidate key is eliminated to achieve which normal form?
Related Database Management PYQs
A relational schema is in Second Normal Form (2NF) if and only if it is in 1NF and:
The natural join of two relations R and S (R ⋈ S) is equivalent to:
In 2-Phase Locking (2PL), what characterizes the 'shrinking phase' of a transaction?
What is the effect of executing an aggregate function (such as AVG, SUM, COUNT) on a column containing NULL values?
If every non-trivial functional dependency X -> Y in relation R satisfies X is a superkey, then relation R is guaranteed to be in:
In SQL, which clause is used to eliminate duplicate rows from the query output?
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.