GATE DA 2025 — Question 33

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

On a relation named Loan of a bank:
Question image
the following SQL query is executed.
sql
1SELECT L1.loan_number
2FROM Loan L1
3WHERE L1.amount > (SELECT MAX (L2.amount)
4                   FROM Loan L2
5                   WHERE L2.branch_name = 'SR Nagar');
6
The number of rows returned by the query is ____________(Answer in integer)
Practise the full 2025 paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
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