Question

Which of the following is CORRECT about database managementsystem's languages?

? Data definition languages are used to specify the conceptualschema only.

? Data manipulation languages are used to create thedatabases.

? Data manipulation languages are used for retrieval, insertion,deletion and modification of data.

? Data definition langauges are only used to update data in theDBMS.

Answer 1

Answer:

Data manipulation languages are used for the retrieval of the,insertion,deletion and modification of data.

Explanation:

Data Manipulation Languages(DML) are used to insert,delete,update,modify the data in the database.

The commands used to do these operations are as following:-

INSERT INTO :-This command is used to insert values in the database.

DELETE:-It is used to delete existing records from the table.

UPDATE:- It is used to modify the records in the table.

SELECT:- It is used to select data from database.