Our Recommendations :-
Follow CA Final FB Page

Explain Data Manipulation Language (DML)

Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 Uma asked almost 3 years ago

    0       0 Answer Now Comment Report
6 Answers
Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 veeru answered over 2 years ago

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

    0       0 Comment Report
Important Note – Preparing for CA Final?
CAKART provides Indias top faculty each subject video classes and lectures – online & in Pen Drive/ DVD – at very cost effective rates. Get video classes from CAKART.in. Quality is much better than local tuition, so results are much better.
Watch Sample Video Now by clicking on the link(s) below – 
For any questions Request A Call Back  
Picsjoin 2017224123730582 Archana answered almost 3 years ago

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.

    0       0 Comment Report
Open uri20170510 32134 1c996lj?1494421732 Anil answered almost 3 years ago

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.

    0       0 Comment Report
Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 Aarti Vadnerkar answered almost 3 years ago

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.

    0       0 Comment Report
Open uri20170510 32134 1uwcnoc?1494421631 Shubhangi Jain answered almost 3 years ago

> 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.

    0       0 Comment Report
Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 lochan answered almost 3 years ago

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

    0       0 Comment Report
Get Notifications
Videos
Books
Notes
Loading
SIGN UP
Watch best faculty demo video classes

These top faculty video lectures will
help u prepare like nothing else can.