Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
Which statement is an example of Data Manipulation Language (DML)?? (DP-900)
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. CREATE
D. UPDATE
Solution
Correct answer: D. UPDATE.
Data Manipulation Language (DML) is a subset of SQL that is used to manipulate data within a database. The DML statements include:
INSERT - to add new data to a database
UPDATE - to modify existing data in a database
DELETE - to remove data from a database
SELECT - to retrieve data from a database
Therefore, the statement "UPDATE" is an example of a Data Manipulation Language (DML) statement.
The other options are not DML statements:
A. REVOKE is a Data Definition Language (DDL) statement used to remove privileges from a user.
B. DISABLE is not a standard SQL statement.
C. CREATE is a Data Definition Language (DDL) statement used to create new database objects such as tables, views, or indexes.
Category: Core Data Concepts