Structured Query Language (SQL) GATE 1991 Question #8827 with Solution

GATE 1991

Database ManagementStructured Query Language (SQL)easyMCQ1 mark

In SQL, the HAVING clause is used to filter:

AGroups created by the GROUP BY clauseBIndividual rows before groupingCTable index structuresDDatabase users

Related Database Management PYQs

Which relational algebra operator is equivalent to the SQL expression 'INTERSECT'?

A clustering index is defined on an ordered data file where the ordering data attribute is:

Armstrong's Transitivity Axiom states that:

Which recovery log record format logs both the old value and the new value of a modified data item?

Which SQL command modifies existing table row data?

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 …

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.