Multiple choice technology databases

What is true about MERGE command? Choose all that apply.

  1. It is a DML command

  2. It is a DDL command

  3. Provides the ability to conditionally update or insert data into a database table

  4. Provides the ability to MERGE VIEWS and INDICES of a TABLE
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

MERGE is a DML (Data Manipulation Language) command, not DDL, because it modifies existing data in tables. It provides UPSERT functionality - conditionally updating existing rows or inserting new ones based on a matching condition. Option D is incorrect because MERGE operates on table data, not on schema objects like views or indices.

Keep practicing — related questions