Question

Define types of DML Commands..in detail.

Class 10..
unit 5. Data base and development..
Answer this fast..
​

Answer 1

Answer:

DML - Data Manipulation Language - anything where you can play around data (create new, update existing, delete)

Explanation:

INSERT - It is used to create new data in database.

UPDATE/MODIFY - its is used to update existing data in database

DELETE - it is used to delete any existing data in database

**SELECT - some places SELECT is categorized under DML, but in my opinion  by using it we dont manipulate anything. Its a separate type ie DQL.

You can elaborate more by adding syntax and some exmaples

Answer 2

DML COMMANDS_________❤️

DML commands allows the users to manipulate data in database.

SELECT:-

IT retrives data from the table.

INSERT:-

Inserts data into a table.

UPDATE:-

Updates the existing data with new data within a table.

DELEATE:-

Deleates the records rows from the table.

MERGE:-

It is used to select the rows from one or more sources for updating or inserting into a table or view .you can specify conditions to determine wheather to update or insert into the target table or view.

LOCK TABLE:-

It used to lock one or more tables in a shared and exclusive mode. Table access is denied to other users for the duration of the table operation.

ExPLAIN PLAN:-

These statements are supported in PL/SQL and oracle DBMS. It displays the query execution plans choosen by oracle optimizer to exclute certain statements..

_______________________❤️

hyy. mate✨

hops this may help you✨

mark my answer as brainliest.