Which of the following are DML commands? Each correct answer represents a complete solution.
Choose all that apply.

A.
SELECT INTO

B.
DELETE

C.
UPDATE

D.
ALTER

E.
SELECT

F.
INSERT

Explanation:
Answer A, C, B, and FA data-manipulation language (DML) is a family of languages to access or manipulate data that is organized by
the appropriate data model.
DML is used for the following operations:
Retrieval of information stored in the database.
Insertion of new information into the database.
Deletion of information from the database.
Modification of information stored in the database.
Currently the most popular data manipulation language is that of SQL, which is used to retrieve and manipulate
data in a Relational database.
In SQL, the following statements are used for database manipulation:
SELECT … INTO
INSERT
UPDATE
DELETE
Each SQL DML statement is a declarative command.
Answer E is incorrect. The purely read-only SELECT query statement is classed with the ‘SQL-data’
statements and hence it is considered to be outsideof DML. The SELECT … INTO form is considered to be
DML because it manipulates or modifies data. AnswerD is incorrect. ALTER is a DDL command.