GATE Computer Science (CS) 2011 Solved Paper

© examsiri.com
Question : 56 of 65
 
Marks: +1, -0
Database table by name Loan_Records is given below.
Borrower
Bank Manager
Loan Amount
Ramesh
Sunderajan
10000.00
Suresh
Ramgopal
5000.00
Mahesh
Sunderajan
7000.00

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
);
Go to Question: