GATE CS 2023 Set 1 — Question 61

NAT+2 / -0EasyDML CommandsSQLDatabases

Databases → SQL → DML Commands

Last updated 5 September 2026

Question

Consider the following table named Student in a relational database. The primary key of this table is rollNum . rollNum name gender marks 1 Naman M 62 2 Aliya F 70 3 Aliya F 80 4 James M 82 5 Swati F 65 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__________.

rollNum	name	gender	marks
1	Naman	M	62
2	Aliya	F	70
3	Aliya	F	80
4	James	M	82
5	Swati	F	65

Correct answer 2 to 2 Solution The SQL query selects rows from the Student table that satisfy two conditions simultaneously: 1. gender must be 'F'. 2. marks must be strictly greater than 65. Let's evaluate each row in the table: Row 1 (Naman): gender = 'M'. Condition fails. Row 2 (Aliya): gender = 'F' (True), marks = 70 > 65 (True). Selected. Row 3 (Aliya): gender = 'F' (True), marks = 80 > 65 (True). Selected. Row 4 (James): gender = 'M'. Condition fails. Row 5 (Swati): gender = 'F' (True), marks = 65. The condition marks > 65 is False (65 is not greater than 65). Condition fails. Total selected rows: 2. Turn this into a strength. Explore AI-powered practice and doubt support with Success Tracker.

Review answer and solution without JavaScript

Interactive answer checking needs JavaScript. The published solution is available below.

Correct answer 2 to 2 Solution The SQL query selects rows from the Student table that satisfy two conditions simultaneously: 1. gender must be 'F'. 2. marks must be strictly greater than 65. Let's evaluate each row in the table: Row 1 (Naman): gender = 'M'. Condition fails. Row 2 (Aliya): gender = 'F' (True), marks = 70 > 65 (True). Selected. Row 3 (Aliya): gender = 'F' (True), marks = 80 > 65 (True). Selected. Row 4 (James): gender = 'M'. Condition fails. Row 5 (Swati): gender = 'F' (True), marks = 65. The condition marks > 65 is False (65 is not greater than 65). Condition fails. Total selected rows: 2.

Continue learning with Success Tracker

Use Success Tracker to ask about the reasoning, then try another GATE CS question to check your understanding.

AI-powered practice· Unlimited practice on eligible plans

PYQs with solutions: Attempt available previous-year questions, then compare your reasoning with the worked solution. Coverage varies by stream.
Practice that adapts: Choose a topic, work on weaker areas and bookmark questions to revisit. Your attempts feed your progress tracking.
AI doubt support: Ask follow-up questions about a step or concept while practising, instead of stopping at the final answer.

Unlimited practice is available on eligible plans. Free practice and AI usage have limits; check the current plan allowances before choosing.

This page stays readable without an account. AI responses can be wrong; check them against the solution and source material.