Relational Model: Relational Algebra and Tuple Calculus GATE 1992 Question #8826 with Solution

GATE 1992

Database ManagementRelational Model: Relational Algebra and Tuple CalculuseasyMCQ1 mark

The project operator (π) in relational algebra is used for:

ASelecting specific columns from a relation and removing duplicatesBFiltering rows based on a conditionCJoining two relationsDSorting tuples

Related Database Management PYQs

In SQL, which clause is evaluated immediately after the WHERE clause during logical query processing?

A dense index has an index entry for:

Which relational algebra operation returns all tuples belonging to relation R, relation S, or both, removing duplicates?

Lossless-join decomposition of a relation schema R into R1 and R2 guarantees that:

Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …

In the context of relational database normalization, which of the following statements is/are true?

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.