To answer this question, we need to understand what DML (Data Manipulation Language) statements are. DML statements are used to manipulate data stored in a database. They include operations such as inserting, updating, deleting, and merging data.
Let's go through each option to determine which ones are DML statements:
Option A) COMMIT - This option is not a DML statement. COMMIT is used to save the changes made to the database since the last COMMIT or ROLLBACK statement. It is a transaction control statement.
Option B) MERGE - This option is a DML statement. The MERGE statement combines insert, update, and delete operations into one statement. It is used to perform conditional updates or inserts based on a specified condition.
Option C) UPDATE - This option is a DML statement. The UPDATE statement is used to modify existing data in a table.
Option D) DELETE - This option is a DML statement. The DELETE statement is used to remove existing data from a table.
Option E) CREATE - This option is not a DML statement. CREATE is a Data Definition Language (DDL) statement used to create database objects such as tables, views, or indexes.
Option F) DROP - This option is not a DML statement. DROP is a DDL statement used to remove database objects such as tables or views.
Based on the explanations above, the correct answers are B) MERGE, C) UPDATE, and D) DELETE. These options are DML statements as they involve manipulating data in a database.