6.Which clause handles updates in MERGE?
-
A. WHEN MATCHED THEN
-
B. WHEN EXISTS THEN
-
C. UPDATE ON MATCH
-
D. SET IF FOUND
WHEN MATCHED THEN
WHEN MATCHED THEN
7.What happens if the ON condition in MERGE never matches?
-
A. Rows are deleted
-
B. Nothing happens
-
C. All new rows are inserted
-
D. Error is thrown
All new rows are inserted
All new rows are inserted
8.Is MERGE supported in all RDBMS by default?
-
A. Yes
-
B. No
No
No
9.MERGE statements should be used when:
-
A. You only need INSERTs
-
B. You only need UPDATEs
-
C. You need both based on conditions
-
D. You want to truncate
You need both based on conditions
You need both based on conditions
10.Which operation is most similar in logic to MERGE?
-
A. TRUNCATE
-
B. UPSERT
-
C. GROUP BY
-
D. SELECT INTO
UPSERT
UPSERT