Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. Database table by name Loan_Records is given below.
    Borrower Bank_Manager Loan_Amount
    Ramesh Sunderajan 100000.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
    );
    1. 3
    2. 9
    3. 5
    4. 6
Correct Option: C




Your comments will be displayed only after manual approval.