Which of the following is not a DDL command?UPDATETRUNCATEALTERNone of the Mentioned
Question
Which of the following is not a DDL command?UPDATETRUNCATEALTERNone of the Mentioned
Solution
To determine which of the following is not a DDL command, we need to understand what DDL commands are. DDL stands for Data Definition Language, and it is used to define and manage the structure of a database.
The options given are:
- UPDATE
- TRUNCATE
- ALTER
- None of the Mentioned
Step 1: Let's analyze each option to see if it is a DDL command.
-
UPDATE: UPDATE is not a DDL command. It is a DML (Data Manipulation Language) command used to modify data in a database. Therefore, it is not a correct answer.
-
TRUNCATE: TRUNCATE is a DDL command used to remove all data from a table, but it does not delete the table itself. This is a valid DDL command.
-
ALTER: ALTER is a DDL command used to modify the structure of a table, such as adding or dropping columns. This is also a valid DDL command.
-
None of the Mentioned: This option suggests that none of the given commands are DDL commands. However, we have already identified that UPDATE is not a DDL command, so this option is not correct.
Step 2: Based on our analysis, the correct answer is: UPDATE.
Therefore, the option "UPDATE" is not a DDL command.
Similar Questions
Which of the following commands is a DDL command?AINSERTBUPDATECCREATE
Which of the following is not a DDL command?CREATEDROPSELECTALTER
Which of the following is/are the DDL statements?
Which of the following command is a type of Data Definition language command?a.Updateb.Mergec.Created.Delete
Which SQL command is used to make permanent changes to data in a database? ans. TCL DCL DDL DML
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.