Quiz on SQL MERGE

What is the purpose of the MERGE statement in SQL?

What does UPSERT mean in SQL terminology?

Which of the following SQL keywords are typically used with MERGE?

What does the ON clause specify in a MERGE statement?

What action is performed in WHEN MATCHED THEN UPDATE?

In MERGE, what happens in WHEN NOT MATCHED THEN INSERT?

Which two clauses are essential in a complete MERGE statement?

Which scenario best describes the use of MERGE?

Which database systems support the MERGE statement?

What can go wrong if the ON clause produces multiple matches for the same target row?

Which of the following statements is TRUE about MERGE?

Can MERGE be used to delete records?

What is the role of an alias in a MERGE statement?

What will this snippet do?

MERGE INTO products p

USING new_products np

ON (p.id = np.id)

WHEN MATCHED THEN UPDATE SET p.name = np.name

WHEN NOT MATCHED THEN INSERT (id, name) VALUES (np.id, np.name);

Which clause is used in PostgreSQL 15+ for upsert behavior if `MERGE` is unavailable?