Question

is not a DDL command.

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

Hint:

A simple way to distinguish DDL and DML: DDL changes the structure (the blueprint of the tables). DML changes the data (the contents of the tables).

Answer 1

The Correct Option is B

SQL commands are broadly categorized into several groups. The two main ones are DDL and DML.
DDL (Data Definition Language): These commands are used to define and manage the database structure or schema. They deal with objects like tables, indexes, etc.
CREATE`: To create database objects. (A)ALTER`: To modify the structure of existing objects. (C)DROP`: To delete database objects. (D)TRUNCATE`: To remove all records from a table (which is a DDL operation because it's faster and cannot be rolled back easily, unlike DELETE).
DML (Data Manipulation Language): These commands are used to manage the data within the schema objects.
INSERT`: To add new data. (B)UPDATE`: To modify existing data. DELETE`: To remove existing data.
SinceUPDATE` is used to modify the actual data within a table, it is a DML command, not a DDL command.