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

Which statement is an example of Data Definition Language (DDL)? (DP-900)

Updated on 08/26/2024


Which statement is an example of Data Definition Language (DDL)?

A. SELECT
B. JOIN
C. UPDATE
D. CREATE


Solution

Correct answer: D. CREATE.
Data Definition Language (DDL) is a subset of SQL that is used to define and manage the structure of a database, including creating, modifying, and deleting database objects such as tables, indexes, and views.
The statement "CREATE" is an example of a DDL statement, as it is used to create new database objects, such as a table or a database.

The other options are not examples of DDL statements:
A. SELECT is a Data Manipulation Language (DML) statement, used to retrieve data from a database.
B. JOIN is a SQL clause used to combine rows from two or more tables based on a related column between them, and it is not a DDL statement.
C. UPDATE is a DML statement, used to modify existing data in a database table.

Therefore, the statement "CREATE" is the only example of a Data Definition Language (DDL) statement in the given options.

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.