GATE | GATE CS 2011 | Question 46


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, 
                      FROM   Loan_Records) AS T );

(A) 3
(B) 9
(C) 5
(D) 6

Answer: (C)


See Question 3 of

Quiz of this Question

GATE CS Corner    Company Wise Coding Practice

Recommended Posts:

2 Average Difficulty : 2/5.0
Based on 1 vote(s)