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:
A 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 outside of DML. The SELECT … INTO form is considered
to be DML because it manipulates or modifies data.
Answer D is incorrect. ALTER is a DDL
command.