---

The DBMS provides data manipulation language (DML) that enables users to retrieve and manipulate the data. The statement that is used to retrieve the information is called a query. The part of the DML used to retrieve the information is called a query language. The DML are of two types, namely, non-procedural DML and procedural DML. The non-procedural or high-level or declarative DML requires a user to specify what data are required without specifying how to retrieve the required data. For example, SQL (Structured Query Language) is a non-procedural query language. The procedural or low-level DML requires the user to specify what data are required and how to access that data by providing a step-by-step procedure. For example, relational algebra is a procedural query language.

Here are some tasks that come under DML:

• Select: It is used to retrieve data from a database.
• Insert: It is used to insert data into a table.
• Update: It is used to update existing data within a table.
• Delete: It is used to delete all records from a table.
• Merge: It performs UPSERT operation, i.e., insert or update operations.
• Call: It is used to call a structured query language or a Java subprogram.
• Explain Plan: It has the parameter of explaining data.
• Lock Table: It controls concurrency.

---