DP-900 · Question #268
Which statement is an example of Data Manipulation Language (DML)?
The correct answer is A. INSERT. Data Manipulation Language (DML) includes statements that modify or retrieve data within existing database objects. INSERT, UPDATE, DELETE, and SELECT are all DML statements.
Question
Options
- AINSERT
- BALTER
- CDROP
- DCREATE
How the community answered
(46 responses)- A89% (41)
- B2% (1)
- C2% (1)
- D7% (3)
Why each option
Data Manipulation Language (DML) includes statements that modify or retrieve data within existing database objects. INSERT, UPDATE, DELETE, and SELECT are all DML statements.
INSERT is a DML statement because it manipulates the data stored within existing tables by adding new rows. DML operates on the data inside database structures rather than defining the structures themselves, making INSERT the correct answer here.
ALTER is a Data Definition Language (DDL) statement used to modify the structure of an existing database object, such as adding or removing columns.
DROP is a DDL statement that removes an entire database object such as a table, view, or index from the schema.
CREATE is a DDL statement used to define and create new database objects such as tables, indexes, or views.
Concept tested: SQL Data Manipulation Language (DML) classification
Source: https://learn.microsoft.com/en-us/sql/t-sql/statements/statements
Topics
Community Discussion
No community discussion yet for this question.