AI-102 · Question #125
Which statement is an example of Data Manipulation Language (DML)?
The correct answer is B. UPDATE. Data Manipulation Language (DML) statements are used to manage and modify data within a database, distinct from commands that define structure or control access.
Question
Options
- ARevoke
- BUPDATE
- CDROP
- DCREATE
How the community answered
(59 responses)- A2% (1)
- B88% (52)
- C3% (2)
- D7% (4)
Why each option
Data Manipulation Language (DML) statements are used to manage and modify data within a database, distinct from commands that define structure or control access.
`REVOKE` is a Data Control Language (DCL) statement used to remove user permissions or privileges on database objects.
`UPDATE` is a standard SQL command used to modify existing records in a database table, which directly manipulates the data and is therefore classified as a DML statement.
`DROP` is a Data Definition Language (DDL) statement used to delete an existing database object, such as a table or view, which defines schema.
`CREATE` is a Data Definition Language (DDL) statement used to build new database objects, such as tables, indexes, or views.
Concept tested: SQL DML commands
Source: https://learn.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.