Databases · Relational Model and SQL
Official IIT answer key · IIT Madras · Audited Aug 2026
GATE CSE 2011 Q46 · MCQ · 2 marks
Loan_Records is given below.
What is the output of the following SQL query?
SELECT count(*)
FROM (
(SELECT Borrower, Bank_Manager FROM Loan_Records) AS S
NATURAL JOIN
(SELECT Bank_Manager, Loan_Amount FROM Loan_Records) AS T
);
Key concept
Topic notes
GATE tests the relational model across three interrelated formalisms: Relational Algebra (RA), Relational Calculus (TRC/DRC), and SQL. Questions evaluate core semantic equivalences, translation between declarative calculi and algebraic operators, table instance tracing (such as joins, group-by aggregations, and division), and corner cases like SQL three-valued logic, duplicate preservation, and safe TRC expressions.
Full Relational Model and SQL guide →Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.