Which statement is an example of Data Definition Language (DDL)?
Click on the arrows to vote for the correct answer
A. B. C. D.D
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
-> ALTER
-> Collations
-> CREATE
-> DROP
-> DISABLE TRIGGER
-> ENABLE TRIGGER
-> RENAME
-> UPDATE STATISTICS
-> TRUNCATE TABLE
-> UPDATE
https://docs.microsoft.com/en-us/sql/t-sql/statements/statementsThe correct answer is D. DROP.
Data Definition Language (DDL) is a set of SQL statements used to define, modify, and delete database structures such as tables, views, and indexes. DDL statements are used to create, alter, or drop database objects.
In the given options, A. SELECT, B. INSERT, and C. DELETE are examples of Data Manipulation Language (DML), which is used to manipulate or retrieve data in a database.
Option D. DROP is an example of DDL, as it is used to delete or remove an existing database object, in this case, a table. The DROP statement removes the table and all associated objects, including indexes, triggers, and constraints.
Therefore, the correct answer is D. DROP.