Which of the following statements are true regarding DML? Each correct answer represents a complete
solution. Choose all that apply.
A.
It enables users to access/manipulate data in a database.
B.
It is used to specify additional properties of the data.
C.
It is used to specify a database schema by a set of definitions.
D.
It can be procedural or declarative.
Explanation:
Answer A and D
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. There are two types of DMLs:
Precedural DMLs: It requires a user to specify whatdata are needed and how to get those data. Declarative
DMLs: It requires a user to specify what data are needed without specifying how to get those data.
Answer C and B are incorrect. Data-definition language (DDL) is used to specify a database schema by aset
of definitions. It is also
used to specify additional properties of the data.