Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes

Which statement is an example of Data Manipulation Language (DML)?? (DP-900)

Updated on 08/08/2024

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

There are no comments yet.

Authentication required

You must log in to post a comment.
Log in to like this solution

Log in

Support us!
Subscribe Now

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All" you consent to our use of cookies. Privacy Policy.