Relational Model: Relational Algebra and Tuple Calculus GATE 2005 Question #7515 with Solution

GATE 2005

Database ManagementRelational Model: Relational Algebra and Tuple CalculuseasyMCQ1 mark

The natural join of two relations R and S (R ⋈ S) is equivalent to:

AA cross product followed by selection on equality of all common attributes and projection to eliminate duplicate columnsBA union of R and S followed by intersectionCA cross product with no attribute filteringDA projection on the primary key only

Save your progress

Related Database Management PYQs

GATE 2005

A relational schema is in Second Normal Form (2NF) if and only if it is in 1NF and:

GATE 2005

In 2-Phase Locking (2PL), what characterizes the 'shrinking phase' of a transaction?

GATE 2005

What is the effect of executing an aggregate function (such as AVG, SUM, COUNT) on a column containing NULL values?

GATE 2005

If every non-trivial functional dependency X -> Y in relation R satisfies X is a superkey, then relation R is guaranteed to be in:

GATE 2005

In SQL, which clause is used to eliminate duplicate rows from the query output?

GATE 2005

Which relational algebra operator is used to alter the name of a relation or its attributes?

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.

Related Database Management PYQs

Turn practice into measurable progress