Test Index

GATE Computer Science (CS) 2011 Solved Paper

© examsnet.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
);

3
9
5
6

Go to Question:

Prev Question

Next Question