To answer this question, you need to understand the Data Definition Language (DDL) and its various commands.
DDL is a subset of SQL (Structured Query Language) that is used to define and manage the structure of a database. It includes commands for creating, modifying, and deleting database objects such as tables, indexes, and views.
Let's go through each option to understand why it is correct or incorrect:
Option A) CREATE - This option is part of the Data Definition Language (DDL). The CREATE command is used to create new database objects like tables, views, indexes, and schemas.
Option B) ALTER - This option is part of the Data Definition Language (DDL). The ALTER command is used to modify the structure of existing database objects, such as adding or deleting columns in a table.
Option C) ALTER SESSION - This option is not part of the Data Definition Language (DDL). The ALTER SESSION command is used to modify the session-specific parameters or settings associated with a user session, such as changing the date format or language settings. It is part of the Data Manipulation Language (DML) rather than DDL.
Option D) None of the above - This option is incorrect because both Option A (CREATE) and Option B (ALTER) are part of the Data Definition Language (DDL). Option C (ALTER SESSION) is the correct answer as it is not part of DDL.
The correct answer is C) ALTER SESSION. This option is not part of the Data Definition Language (DDL) because it belongs to the Data Manipulation Language (DML).