Question

1. Which of the following is not a DDL command?
(1 Point)
UPDATE
DROP
ALTER
CREATE​

Answer 1

Answer:

UPDATE is not a DDL command.

Explanation:

What is DDL in SQL?

The set of SQL commands known as Data Definition Language (DDL) can be used to design and modify database structures. Indexes, triggers, tables, and views are all examples of objects that can be created, modified, or removed using DDL statements. DDL statements frequently used include CREATE (generates a new table) and ALTER (alters table). Language for defining data. The structure of your tables and other database objects is created and modified using DDL statements. A DDL statement is effective right away after execution.

What is DML in SQL?

The alteration of data records kept in database tables is handled by Data Manipulation Language (DML) instructions in SQL. Changes to the structure and objects of the database are not addressed. The DML commands INSERT, UPDATE, and DELETE are the most well-known.

Thus, UPDATE command will fall under DML in SQL.

Answer 2

Answer:

UPDATE  is not a DDL command.

Explanation:

DDL COMMANDS:

DDL stands for Data Definition Language. It consists of those SQL statements that define the definition of the database and the table.

DDL has the following commands:

CREATE Command

It is used to create the database and the table.

DROP Command

It is used to delete the database and the table of the database.

ALTER Command

Alter command is useful when we want to make any modification in the structure or definition of the database.

From the given optoins it is clearly visible that UPDATE is not a DDL command. It comes under the category of DML (Data Manipulation Command)

So the UPDATE is the correct answer.

#SPJ3