Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
Which statement is an example of Data Definition Language (DDL)? (DP-900)
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