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.
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
);
|
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: