SOLVED: Consider the following data in two tableLoanDetails:EMIPaymentdetails:What will ...

Consider the following data in two table

LoanDetails:

EMIPaymentdetails:

What will be the output on executing the below code?

MERGE LoanDetails AS LD
USING EMIPaymentDetails AS EMI
ON LD.Loanid = EMI.Loanid
WHEN MATCHED THEN 
UPDATE SET LoanAmount = LoanAmount-EMI.Amountpaid
WHEN NOT MATCHED THEN 
UPDATE SET LoanAmount = LoanAmount+1500;

4 rows will be updated

Error. Update is not allowed in the WHEN NOT MATCHED condition

2 rows will be updated

Error. MATCHED condition can’t update the target Table

Verified Answer

Correct Option - b

To get all Infosys Certified MS SQL Server Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Quick Links

Legal

Contact Info