1.What is the purpose of the MERGE statement in SQL?
-
A. To split a table
-
B. To delete duplicate rows
-
C. To conditionally insert or update data
-
D. To rename columns
To conditionally insert or update data
To conditionally insert or update data
2.Which clause is mandatory in a MERGE statement?
-
A. ON
-
B. WHERE
-
C. HAVING
-
D. GROUP BY
ON
ON
3.MERGE combines functionality of:
-
A. INSERT + SELECT
-
B. UPDATE + DELETE
-
C. INSERT + UPDATE + DELETE
-
D. DROP + ALTER
INSERT + UPDATE + DELETE
INSERT + UPDATE + DELETE
4.Which SQL Server syntax is correct for merging?
-
A. MERGE INTO target_table USING source_table ON condition
-
B. MERGE target_table FROM source_table ON condition
-
C. UPDATE target_table FROM source_table
-
D. MERGE target_table BY source_table
MERGE INTO target_table USING source_table ON condition
MERGE INTO target_table USING source_table ON condition
5.Which clause is used in MERGE for new records?
-
A. WHEN MATCHED THEN
-
B. WHEN NOT MATCHED THEN
-
C. IF NEW THEN
-
D. ELSE ADD
WHEN NOT MATCHED THEN
WHEN NOT MATCHED THEN