What is the purpose of the DML language commands in SQL?
- to create, modify or delete objects in the database schema
- to manage updates to the database storage
- to select, update, insert or delete records and values from a table
- to change rights and permissions to data in the database
| Explanation & Hint:
The Data Manipulation Language stores, modifies, retrieves, and deletes data in a database table. DML includes the most common SQL commands, including SELECT, INSERT, UPDATE and DELETE. |