Which is NOT a DDL Command in SQL?

A. 'select'

The correct answer is A. 'select'. Here's why:

• Data Definition Language (DDL) commands are used to define and modify the structure of a database. This includes creating, altering, and deleting tables, indexes, and other database objects.
• Data Manipulation Language (DML) commands are used to manipulate the data within a database. This includes inserting, updating, deleting, and retrieving data.

DDL commands:

• CREATE: Used to create new database objects (tables, indexes, views, etc.).
• ALTER: Used to modify existing database objects.
• TRUNCATE: Used to remove all data from a table, but not the table itself.

DML commands:

• SELECT: Used to retrieve data from a database.
• INSERT: Used to add new data into a table.
• UPDATE: Used to modify existing data in a table.
• DELETE: Used to remove data from a table.