Explain Data Manipulation Language (DML)

Data Manipulation is: - retrieval of information from the database - insertion of new information into the database - deletion of information in the database - modification of information in the database

Hie Uma, - A data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. - This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases.

ML stands for Data Manipulation Language so any statement that manipulates data would be DML, like SELECT, INSERT, UPDATE, DELETE, and MERGE. Another type of T-SQL statements are DDL (Data Definition Language) and this is where you define the structures for your data like CREATE, ALTER, DROP. A third type would be Access Control which would be things like GRANT, REVOKE, DENY. I don't think these fit in DML or DDL. DML stands for 'Data Manipulation Language' and covers all T-SQL statements that retrieve, store or modify data. DDL is the other main category, and stands for 'Data Definition Language'. This covers T-SQL statements that modify objects in the schema. Edit -> thought i should mention the other categories, as Jack did. You have DCL - 'Data Control Language' - which as Jack says is to do with data security. Then you have TCL - 'Transaction Control Language' - which are statements to do with opening and closing transactions. This parameter specifies the maximum number of DML locks. A DML lock is used for each table-modification transaction. DML locks are used in the DROP TABLE, CREATE INDEX, and LOCK TABLE IN EXCLUSIVE MODE statements. If the value is set to 0, enqueues (Oracle locking mechanisms) are disabled, which improves performance slightly.

The Data Manipulation Language (DML) is used to retrieve, insert and modify database information. These commands will be used by all database users during the routine operation of the database.

> Data Manipulation Language (DML) 1. **Data Manipulation is:** - `retrieval` of information from the database - `insertion` of new information into the database - `deletion` of information in the database - `modification` of information in the database 2. A DML is a language which enables users to access and manipulate data. The goal is to provide efficient human interaction with the system. 3. **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 4. A query language is a portion of a DML involving information retrieval only. The terms DML and query language are often used synonymously.

A language that enables users to access or manipulate data (retrieve, insert, update, delete) as organized by a certain Data Model is called the Data Manipulation Language (DML). It can be of two types: - 1. Procedural DML - It describes what data is needed and how to get it. For example: - Relational Algebra. 2. Non-Procedural DML - It describes what data is needed without specifying how to get it. For example: - Relational calculus. Thanks