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:
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 what data 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 a set of definitions. It is also
used to specify additional properties of the data.