DP-900 · Question #303
Which statement is an example of Data Definition Language (DDL)?
The correct answer is C. CREATE. DDL statements define or modify database objects (schema), while DML statements manipulate the data within those objects.
Question
Options
- ASELECT
- BINSERT
- CCREATE
- DMERGE
How the community answered
(41 responses)- A7% (3)
- B2% (1)
- C88% (36)
- D2% (1)
Why each option
DDL statements define or modify database objects (schema), while DML statements manipulate the data within those objects.
SELECT is a DQL/DML statement that retrieves data from existing tables; it does not define or modify schema objects.
INSERT is a DML statement that adds rows of data into an existing table; it operates on data, not schema structure.
CREATE is a DDL command that defines a new database object such as a table, view, index, or schema; DDL commands alter the structure of the database rather than its data.
MERGE is a DML statement that performs conditional INSERT, UPDATE, or DELETE operations on data; it does not create or alter schema objects.
Concept tested: SQL DDL vs. DML command classification
Source: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql
Topics
Community Discussion
No community discussion yet for this question.