Database table by name Loan_Records is given below. Borrower Bank_Manager…
PYQ GATE 2011
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 );
- A.
3
- B.
9
- C.
5
- D.
6
Attempted by 298 students.
Sign up free to check your answer
Sign up freeLoading lesson…

