Databases · SQL
Official IIT answer key · IIT Kanpur · Audited Aug 2026
GATE CSE 2023 Q61 · NAT · 2 marks
Student in a relational database. The primary key of this table is rollNum.
The SQL query below is executed on this database.
SELECT *
FROM Student
WHERE gender = 'F' AND
marks > 65;
The number of rows returned by the query is _________.
Key concept
Topic notes
In GATE CS, SQL is tested through a balanced mix of declarative query semantics, relational-algebra correspondence, subquery evaluation (correlated, nested, and universal quantification), and instance-level tracing. Questions range from conceptual integrity rules (DDL constraints, FOREIGN KEY targets, GROUP BY/HAVING rules) to practical computation of output row counts and aggregate values on small database instances. Recent papers strongly emphasize NAT execution traces and multi-correct (MSQ) equivalent query formulations.
Full SQL guide →Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.