Which of the following is not a DDL command?UPDATETRUNCATEALTERNone of the Mentioned
Question
Which of the following is not a DDL command?
UPDATE
TRUNCATE
ALTER
- None 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 is not a DDL command?UPDATETRUNCATEALTERNone of the Mentioned
Which DDL command is not used to modify the data type of a column in a table?a.ALTER COLUMNb.MODIFY COLUMNc.CHANGE COLUMNd.UPDATE COLUMN
Which of the following command is a type of Data Definition language command?a.Deleteb.Mergec.Created.Update
Which of the following are TCL commands?UPDATE and TRUNCATESELECT and INSERTGRANT and REVOKEROLLBACK and SAVEPOINT
DDL is the abbreviation ofAData Definition LanguageBData Derivation LanguageCDescription Language
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.