Skip to content
Related Articles

Related Articles

Improve Article

GATE | GATE CS 2011 | Question 46

  • Difficulty Level : Easy
  • Last Updated : 15 Oct, 2019

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


Answer: (C)

Explanation:

See Question 3 of http://www.geeksforgeeks.org/database-management-systems-set-4/


Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :