PrepAway - Latest Free Exam Questions & Answers

Which of the following statements are true regarding DML?

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

PrepAway - Latest Free Exam Questions & Answers

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.

One Comment on “Which of the following statements are true regarding DML?

  1. Lena says:

    There are two types of DML:
    procedural: the user specifies what data is needed and how to get it
    nonprocedural: the user only specifies what data is needed
    Easier for user
    May not generate code as efficient as that produced by procedural languages




    0



    0

Leave a Reply