Discussion Forum

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Advanced SQL Mcqs
  8. »
  9. Πcustomer_name, loan_number, amount (borrower ⋈loan)What...
Πcustomer_name, loan_number, amount (borrower ⋈loan)What does the above expression perform?

It finds the customer_name, loan_number and amount from borrower

It finds the customer_name, loan_number and amount from loan

It finds the customer_name, loan_number and amount from the full outer join of borrower and loan

It finds the customer_name, loan_number and amount from the natural join of borrower and loan

Answer: D . It finds the customer_name, loan_number and amount from the natural join of borrower and loan
0Shares
0 0

If you think the posted answer is wrong or Confused About the Answer? Ask for Details Here

Know Explanation? Add it Here
we’ll review your comment and contact you soon….

Leave a Reply

Your email address will not be published. Required fields are marked *

0Shares
0
Scroll to Top