Question

Which of the followings is right about DML ?

Select one or more:
a. All of the others
b. Use to retrieve, insert, update, and delete
c. No affect on the content of the database or extract data from database
d. No affect on the schema of the database

Answer 1

DML is used to perform operations like retrieval, insertion, updating, and deletion of data in a database without affecting its structure. The correct options about DML are that it is used for data manipulation and does not affect the schema of the database.

Step-by-step explanation:

The Data Manipulation Language (DML) is an essential subset of SQL used for managing data in databases. DML allows users to perform various operations on the data within a database. The correct statements about DML are:

• It is used to retrieve, insert, update, and delete data within a database.
• It does not affect the schema (structure) of the database; DML commands only affect the data.

Therefore, the accurate options regarding DML are:

1. Use to retrieve, insert, update, and delete (Option b).
2. No affect on the schema of the database (Option d).

Option a, 'All of the others', is not correct because option c inaccurately states that DML has no effect on database content, whereas DML does indeed have the ability to modify content.