Which of the following is TRUE about the MERGE statement?

Question $10$Select one:

A$.$

In a MERGE statement, you can have only one $$when matched$$ and one $$when not matched$$ clause

B$.$

A target table row can be operated on using an INSERT, UPDATE, or DELETE statement only once

C$.$

The NOT ATOMIC CONTINUE ON SQLEXCEPTION clause will allow you to MERGE one Db$2$ table with another Db$2$ table or a view

D$.$

If you use the IGNORE option, then you can$$t use the SIGNAL statement to provide customized error codes and messages