Oracle Changes in exam delivery Interface compared to olden days .
I have a doubt in one question i encountered while reading Informatica exam dumps. Question: Which tree are true?
A. A merge statement is used to merge the data of one table with data from another.
B. A merge statement replaces the data of one table with that of another.
C. A merge statement can be used to insert new rows into a table.
D. A merge statement can be used to update existing rows in a table. Correct answer was given as A ,B and C. I'm very much certain about A, B, C and it seems like all are correct. I think a merge statement can be used to update existing rows in a table as it normally does if the row exist in table. then why they have not included d in the answer.
Please help with your advice.