nerdexam
Microsoft

DP-900 · Question #275

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

The correct answer is C. Data Manipulation Language (DML). Data Manipulation Language (DML) encompasses SQL statements that read or modify the data stored within database tables. SELECT, INSERT, and UPDATE all operate on data rather than on the structure of the database.

Submitted by jian89· Mar 30, 2026Identify considerations for relational data on Azure

Question

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Options

  • AData Definition Language (DDL)
  • BData Control Language (DCL)
  • CData Manipulation Language (DML)

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    7% (2)
  • C
    89% (24)

Why each option

Data Manipulation Language (DML) encompasses SQL statements that read or modify the data stored within database tables. SELECT, INSERT, and UPDATE all operate on data rather than on the structure of the database.

AData Definition Language (DDL)

Data Definition Language (DDL) includes statements like CREATE, ALTER, and DROP that define or modify the schema and structure of database objects, not the data within them.

BData Control Language (DCL)

Data Control Language (DCL) includes statements like GRANT and REVOKE that control access permissions and security privileges on database objects.

CData Manipulation Language (DML)Correct

DML statements interact with the data contained within database objects rather than defining or controlling those objects. SELECT retrieves data, INSERT adds new rows, and UPDATE modifies existing rows - all three manipulate data in place, making them DML. This contrasts with DDL (which defines structures) and DCL (which manages permissions).

Concept tested: SQL DML vs DDL vs DCL classification

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

Topics

#DML#SQL statements#SELECT INSERT UPDATE

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice