DML Examples

D

Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

BULK INSERT -

DELETE -

INSERT -

SELECT -

UPDATE -

MERGE -

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

The correct answer is D. UPDATE.

Explanation:

Data Manipulation Language (DML) is a category of SQL statements that are used to manipulate data within tables. These statements include INSERT, UPDATE, DELETE, and MERGE.

A. REVOKE is a Data Control Language (DCL) statement. It is used to revoke or remove permissions granted to a user or role in a database.

B. DISABLE is not a SQL statement. It is a term that can be used in the context of disabling features, services, or functionality within a database management system.

C. CREATE is a Data Definition Language (DDL) statement. It is used to create database objects such as tables, views, and indexes.

D. UPDATE is a DML statement that is used to modify existing data within a table. It allows users to update one or more columns in a row or set of rows based on specified conditions.

Therefore, the correct answer is D. UPDATE, as it is an example of a Data Manipulation Language (DML) statement used to modify data within a table.