Data Manipulation Language (DML) in Microsoft Azure Data Fundamentals

Data Manipulation Language (DML)

Question

Which statement is an example of Data Manipulation Language (DML)?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

C

Data Manipulation Language (DML) statements:

-> DELETE

-> INSERT

-> UPDATE

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

The correct answer is C. INSERT.

Explanation:

Data Manipulation Language (DML) is a subset of SQL that is used to manipulate data stored in a database. It is used to perform operations on individual records or data objects such as inserting, updating, deleting, and querying data.

Out of the options given, REVOKE, DISABLE, and GRANT are Data Definition Language (DDL) commands, which are used to define the structure of a database, rather than manipulating data within it.

INSERT, on the other hand, is a DML command, which is used to insert new rows of data into a table.

Therefore, the correct answer is C. INSERT.