Question

What is the difference between DDL and DML in DBMS?

26 Apr 2023
Answer :
Word Count : 1256

In DBMS (Database Management System), DDL (Data Definition Language) and DML (Data Manipulation Language) are two fundamental components used for managing and manipulating data within a database. Here are the differences between DDL and DML:

DDL (Data Definition Language):

  1. Purpose: DDL is used to define the structure and schema of the database. It focuses on creating, modifying, and deleting database objects, such as tables, indexes, views, and constraints.
  2. Actions: DDL statements define the database structure, including creating, altering, or dropping database objects. It allows the creation of new tables, modification of existing tables, and control over data integrity through constraints.
  3. Examples: Common DDL statements include CREATE, ALTER, and DROP. For example, CREATE TABLE is used to create a new table, ALTER TABLE is used to modify the structure of an existing table, and DROP TABLE is used to delete a table.
  4. Impact: DDL statements have a significant impact on the overall database structure and schema. They define the data types, constraints, relationships, and other attributes of the database objects.
  5. Execution: DDL statements are executed immediately and permanently modify the database structure. They are typically executed by database administrators or users with elevated privileges.

DML (Data Manipulation Language):

 

  1. Purpose: DML is used to manipulate and retrieve ____ ____ _____ _____ __________ _____ __________.
    ________ __________ ___ __________ ______ __________ _____ ____ ___ ________ __________ ____.
    _______ ___ _______ ______ ____ ___ __________ ____ ___ ___.
    ________ ___ ___ ________ ___ ____ _____ ____ ___.
    ______ ____ ___ ____ __________ ______ _____.
    ________ _________ ___ ____ ___ _____ __________ ____ ________.
    ______ _________ _______ ____ _________ _______ _________.
    ____ _______ ________ __________ _______ _______ _______.
    ___ _____ ______ _____ ____ ___.
    ________ _____ ________ ________ ___ _____ _____ __________ ____ ________.
    ________ _________ _________ ______ __________ ______ ______ __________ ___ _______.
    _________ _______ ______ _________ ______ ____ _____ _________ ___ ____.
    ______ _____ _____ ____ _______ ______ ___.
    ______ ________ ______ ___ ______ ___ _________ __________.
    ________ _____ _________ ______ ___ ________.
    ___ ____ _______ ______ ____.
    _____ __________ ______ _____ ____ ___ ____.
    ____ ___ ____ _______ _______ _________ ___ _________ ______ _________.
    _____ __________ __________ ____ ________ ______ ____ _____.
    _____ _____ ____ ________ _____.
    __________ ________ ____ ____ ______ _________ ___ ______.
    ________ ______ _____ ____ ___ __________ ___ _____.
    ________ ____ ______ _______ ___ ______ ______.
    ________ _________ ________ ____ _____ _________.
    _______ ___ ___ ______ _______ ________ __________ _______ _________ _____ _________.
    __________ ____ ______ _____ __________.
    _____ __________ __________ ________ _____ ___.
    __________ ____ _______ ______ ________ ___ ____ ______ _____ ______ ________.
    __________ _______ ____ ________ _______ _________ ______ _________ ________.
    ___ _________ _______ ___ _____.
    ___ ________ ________ ___ _______ _________ _____ _________ ________ _______ ______.
    ____ _________ ___ ________ _________ ____ ________ _______.
    ____ ________ ____ _________ _________.
    ________ _______ ________ ______ ____ __________ _________.
    _____ ___ ___ ___ __________ _________.
    ___ ____ _______ ______ _______ ____ _________ _____ ___ ____ _____ ______.
    ____ _____ ____ _____ __________ _________.
    ___ _________ _____ ______ ___.
    ______ _____ _______ ______ _________ ________ ___ ___ __________ _________.
    _______ ______ _____ ___ ___ _____ __________ ________.
    ___ _________ _________ ______ ____ ___ ________.
    _________ __________ _______ _____ _________.
    ____ _____ ________ _______ ____ ___.
    _________ ____ ______ _________ ____ ____ ________ ____ ___ ___ ____.
    ______ __________ ________ _____ ______ ________ _____ _____ ________ ________ _____ ___.
    ___ _________ ____ ____ ________ ___ _______ ________ _____ __________ ________.
    ____ ______ __________ ____ ______ _____ _________ _______.
    __________ ________ ________ _____ ________ _____ ________ ________ _______ ___ _______.
    _____ ____ ________ ____ _______ _______ __________ __________ ________.
    ______ _____ _______ ___ ___ __________ _________ ___.
    __________ _______ ___ __________ ______.
    __________ _________ ________ ______ ________ ________ ______ __________.
    __________ ___ _____ ________ _____ ____.
    _________ _________ ___ __________ _______ ______ _________ ____ ___ ________.
    ____ ________ ______ __________ _____ __________ ________ ______.
    _______ ______ _____ ____ _____ _____ _______ _______.
    __________ _____ _________ ______ _______ _______ ____.
    _________ _______ ______ ____ _______ ________.
    __________ ______ ___ ___ _________ _____.
    ______ _____ ________ ________ _______ _________.
    _____ ___ _________ __________ ___ _____ __________ ________ _________.
    _______ _____ __________ ________ ____ _______ ____ _____ ____.
    __________ ______ _______ ___ ____ ________ _______.
    _________ __________ ______ _____ ______ ______ _______ _______ ___ ________.
    __________ ____ _______ _________ __________ ______ ______ ______ ___ _________.
    __________ __________ _______ __________ _____ _______ ______ ________ _________ ________ ______ _____.
    _________ ________ ____ __________ __________ _______ _____ ___ ___ ____ ____ _____.
    __________ __________ ____ __________ ____ ________ _________ _________ ______.
    _____ ___ _________ _____ ___ _________ ______ _____ ________ _________.
    __________ ____ ______ _____ ________.
    _____ _________ __________ ________ ___ _________.
    ___ _______ _________ ______ _________ _________.
    _________ _____ _______ ____ _______.
    _______ _________ _________ ____ ____ _____ ____ ___ _______ ___ _______.
    ______ ___ _______ ____ _______ _________ ____ __________ ________ ___.
    ________ ______ _____ ____ ___ _________.
    ________ ______ ______ _________ ____ _________ ________.
    _____ __________ _____ ______ _______ __________ ____ ______ ____ __________.
    _____ _____ __________ __________ ___ ________ __________ _____ _________.
    ___ ______ ________ _______ __________ ___ ______ _____ ______ _________.
    _________ ___ ___ _____ _____ _________ _____ _______ __________ _________ _____.
    _____ _______ _____ ______ ________ ________ ______.
    __________ ______ _____ _________ _____ ______ _______.
    ____ _______ _________ ____ ________ ___ ___ ___.
    _________ _____ _________ ______ ____ _____ __________.
    __________ _________ ___ _____ _______ __________ ________ __________ _____ ______ ________.
    ___ _____ ____ ____ _________ ________.
    ______ _____ ________ _________ ___.
    ____ ________ _________ ______ ________ ____ ___ ______ _______ ________ ____.
    _________ __________ __________ ___ __________ ______ _______ ____ ________ ___ ____.
    ____ ________ ____ _________ __________ ________ __________ _____ ______.
    __________ __________ ______ ________ _______.
    ______ ___ __________ ______ __________.
    ____ _________ ___ ______ ____ ________ ________ _________.
    __________ _________ _________ ___ ________ ________ ___ ______ ___ ________.
    ____ ________ _________ __________ ______ _________ _____ _________ _____ ______ __________ ____.
    __________ ___ ________ ______ __________ ___ ______ _______ __________ __________.
    _________ _______ ____ ______ __________ ____ _______.
    ____ ___ _____ _____ ____ __________.
    _________ __________ ______ _________ ____ ____.
    ____ _______ ______ __________ _________ __________.
    _________ _____ _______ ______ __________ ______.
    ________ _________ _________ _____ __________ _____ ____ ___ ___ ________.
    _________ ____ ______ _________ __________ __________ __________ ____ ________ ____.
    _____ _________ __________ __________ ______ _________ ___ ________ __________ _____.
    _____ _______ ________ _______ _____ _____ ________ ________ ___ __________ _____ _____.
    ________ _______ ___ _________ ________ ________.
    ____ _______ ________ _____ ________ _______.
    ________ ____ __________ _______ ___ ______.
    ________ ____ _____ ___ _______ __________ ______.
    _____ ____ _____ ___ ____ ____ _____ ______.
    _________ ___ ___ __________ ______ ___ _________ ___ _______ _________ ________.
    ______ ____ _______ ______ _______ ____ __________ ____ ____.
    _______ _______ _________ ______ _______ _________.
    ___ ________ ___ _____ _______ ___ ______ ______ ______ __________ __________ _______.
    ________ ___ ___ __________ __________ ____.
    ___ ______ ______ ________ _________.
    ________ ____ _______ ____ ___ ___.
    ____ _________ ___ _________ ______ ________ ________ ____.
    ____ _________ ______ _______ ______ _____ ____.
    _____ _________ ______ _____ ________ _______ ____ _____ _______ ______.
    _________ _______ ________ __________ ___ ______ __________.
    _______ _______ ___ _______ _______ ________ _________ ______.
    _____ _______ _______ _________ ___ __________ _____ _____ __________ ______ ______ ________.
    ________ _____ ________ __________ __________ ___ __________ ______ ________ __________ ___ __________.
    ___ _____ ___ ______ ________ __________ __________ _______ ______.
    ______ _________ _____ _____ ________ _______ ________ ______.
    __________ ____ ___ ___ _____ ___ ____ ______ _______ __________.
    _______ ____ ______ ___ ___ ____ _________.
    Get Full Answer on WhatsApp
Related Questions

Write down main functions of the Operating System. Write down the advantages and disadvantages of Batch Operating System

What is a Browser? Explain any five features of a Browser.

Explain the advantages and disadvantages of blogging.

IGNOU needs to send a letter to each student of the BSSI-012 course, informing them of the location of their examination center. The major portion of the text is the same for each student, but the roll number, name of the student and examination center location are different. These details are available in a data file for each student (one file with all the data). What are the steps you would follow to make a personalized letter in Microsoft Word for each student so that each one feels the letter has been drafted for him or her alone?

What are the characteristics and advantages of a Local Area Network? Explain any one LAN topology with the help of a diagram

What is difference between Virus and Anti-Virus? Write the names of some viruses.

 Explain the difference between System Software and Application Software

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login Cart
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance What is the difference between DDL and DML in DBMS?
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→