1. Data Manipulation is:
- retrieval of information from the database
- insertion of new information into the database
- deletion of information in the database
- modi cation of information in the database
2. A DML is a language which enables users to access and manipulate data.
The goal is to provide ecient human interaction with the system.
3. There are two types of DML:
procedural: the user speci es what data is needed and how to get it
nonprocedural: the user only speci es what data is needed
- Easier for user
- May not generate code as ecient 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.