Question

Which of the following is not a DDL command in SQL?

• A. DROP
• B. CREATE
• C. UPDATE
• D. ALTER

Hint:

Remember, DDL commands deal with the structure of the database (e.g., CREATE}, DROP}), while DML commands (e.g., UPDATE}, INSERT}) handle the data within the tables.

Answer 1

The Correct Option is C

UPDATE is a Data Manipulation Language (DML) command used to modify data in existing rows of a table. On the other hand, DROP, CREATE, and ALTER are Data Definition Language (DDL) commands, which are used to define and modify the structure of a database.