GATE DA 2024 — Question 31

Database Management and Warehousingrelational model: relational algebra, tuple calculus, SQLNAT1 markEasy

Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi league. The attribute ID in table Team references the primary key of the Raider table, ID.
Question image
The SQL query described below is executed on this database:
sql
1SELECT *
2FROM Raider, Team
3WHERE Raider.ID=Team.ID AND City="Jaipur" AND
4RaidPoints > 200;
5
The number of rows returned by this query is ______.
Practise the full 2024 paper
Challenge a friend: WhatsApp Telegram
From RENYXERAPractise this subject in the exam simulatorTimed, GATE-style tests with analytics that find your weak topics.
Practise more on relational model: relational algebra, tuple calculus, SQLTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group