DML Statements Notes in PDF Free to Download

DML Statements

Click On the Download Button Below 👇

Introduction to DML Statements :-

DML commands are used to modify the database. It is responsible for all form of changes in the database.The command of DML is not auto- committed that means it can’t permanently save all the changes in the database. They can be rollback.

Here are some commands that come under DML:

  • INSERT
  • UPDATE
  • DELETE

Objectives of DML Statements :-

  • Manipulate Data: Allow users to insert, update, delete, and retrieve data from tables.
  • Ensure Data Consistency: Maintain consistency and integrity during data modifications.
  • Support Querying: Enable efficient querying through commands like SELECT for retrieving data.
  • Facilitate Transactions: Manage changes within a transaction, ensuring data is consistent and accurate.
  • Control Data Access: Allow for authorized users to modify data while protecting data integrity.

Summary of DML Statements :-

DML (Data Manipulation Language) statements are used to manipulate and manage data within a database. Key operations include:

  • INSERT: Adds new records to tables.
  • UPDATE: Modifies existing records.
  • DELETE: Removes records from tables.
  • SELECT: Retrieves data from one or more tables.

These statements allow users to interact with and modify the data while maintaining data integrity.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top