Table Student (rollNum PK, name, gender, marks): rows (1,Naman,M,62), (2,Aliya,F,70), (3,Aliya,F,80), (4,James,M,82), (5,Swati,F,65). SQL: SELECT * FROM Student WHERE gender='F' AND marks > 65. The number of rows returned is ___

Answer: 2Concept -- SQL SELECT with WHERE clause (from Ramakrishnan and Gehrke, Database Management Systems):Filter rows where gender = 'F' AND marks > 65:Row 1 (Naman, M, 62): gender = M, fails.Row 2 (Aliya, F, 70): gender = F AND 70 > 65 = TRUE. Included.Row 3 (Aliya, F, 80): gender = F AND 80 > 65 = TRUE. Included.Row 4 (James, M, 82): gender = M, fails.Row 5 (Swati, F, 65): gender = F but 65 > 65 is FALSE (strict inequality). Excluded.Rows returned: 2 (rows 2 and 3). Answer = 2.

GATE-CS is a competitive examination conducted in India. This question is from the 2023 GATE-CS Database Management Systems paper.

How can I prepare for GATE-CS Database Management Systems?

To prepare for GATE-CS Database Management Systems, practice previous year questions (PYQs), understand concepts thoroughly, and solve mock tests regularly. This 2023 question covers SQL (Joins, Subqueries, Group By, Aggregation) topic.

What is the difficulty level of this question?

This GATE-CS 2023 Database Management Systems question has a easy difficulty level.

Where can I find more GATE-CS previous year questions?

You can find more GATE-CS previous year questions on AspirantMitraa. Browse by subject, topic, year, and difficulty level to practice effectively.

GATE-CS Database Management Systems 2023 - Table Student...

Students(rollno, name, age, cgpa), Courses(courseno, cname, credits), Enrolled(rollno, courseno, gra…

MEDIUM2025GATE-CSDatabase Management Systems

Consider the database query (SQL) on sports league tables player(pid,pname,age), coach(cid,cname), t…

MEDIUM2025GATE-CSDatabase Management Systems

Consider the following SQL query: SELECT * FROM Student AS S WHERE NOT EXIST (SELECT cNo FROM Course…

HARD2022GATE-CSDatabase Management Systems

SQL query: SELECT deptId, count(*) FROM emp WHERE gender='female' AND salary > (SELECT avg(salary) F…

EASY2021GATE-CSDatabase Management Systems

Consider the following relational database. Suppliers(sno, sname, location): S1-Royal furniture-Delh…

MEDIUM2020GATE-CSDatabase Management Systems

Relational database with Student (Roll_no, Student_name) and Performance (Roll_no, Subject_code, Mar…

HARD2019GATE-CSDatabase Management Systems

Table Student (rollNum PK, name, gender, marks): rows (1,Naman,M,62), (2,Aliya,F,70), (3,Aliya,F,80), (4,James,M,82), (5,Swati,F,65). SQL: SELECT * FROM Student WHERE gender='F' AND marks > 65. The number of rows returned is ___

Master GATE-CS with Our Test Series

More Questions from SQL (Joins, Subqueries, Group By, Aggregation)

Frequently Asked Questions

Table Student (rollNum PK, name, gender, marks): rows (1,Naman,M,62), (2,Aliya,F,70), (3,Aliya,F,80), (4,James,M,82), (5,Swati,F,65). SQL: SELECT * FROM Student WHERE gender='F' AND marks > 65. The number of rows returned is ___

Master GATE-CS with Our Test Series

More Questions from SQL (Joins, Subqueries, Group By, Aggregation)

Frequently Asked Questions