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.
Question
Options
- AData Definition Language (DDL)
- BData Control Language (DCL)
- CData Manipulation Language (DML)
How the community answered
(27 responses)- A4% (1)
- B7% (2)
- C89% (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.
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.
Data Control Language (DCL) includes statements like GRANT and REVOKE that control access permissions and security privileges on database objects.
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
Community Discussion
No community discussion yet for this question.