Question

What is the difference between DDL and DML in DBMS?

19 Feb 2025
Answer :
Word Count : 1115

In Database Management Systems (DBMS), Data Definition Language (DDL) and Data Manipulation Language (DML) are two distinct categories of SQL commands, each serving different purposes. Understanding the differences between them is crucial for anyone working with databases, especially when it comes to creating, managing, and manipulating data. DDL and DML are both essential components in the interaction between users and databases, but they differ in their functionality, scope, and the types of tasks they handle.

Data Definition Language (DDL):

DDL refers to the set of SQL commands that are used to define and manage the structure of a database. It is primarily concerned with the creation, alteration, and deletion of database objects such as tables, schemas, and indexes. DDL commands describe how the data should be stored, organized, and related within the database. These commands do not manipulate the data itself but deal with its schema and structure.

Key DDL Commands include:

  1. CREATE: This command is used to create new database objects such as tables, views, schemas, indexes, or even entire databases. For example, a CREATE TABLE command is used to define a ______ _______ ____ _____ _________.
    __________ _________ ____ ___ ________ _________ ____ __________ _________.
    _________ _____ _______ _________ _________ _________.
    ______ ____ _______ _____ ________ __________ ____ ________ _____ _____ __________ ____.
    __________ _____ _______ _____ ______ _______ ___ __________ __________ ____ ________.
    _________ _______ _______ ____ _____ ___ ___ ___.
    ___ __________ _________ __________ ____ _________.
    ______ _______ ______ ______ _______ _______ __________ _____ ___ __________ ____.
    _________ _____ ____ _____ __________ ___ ______ _____ ______ _____.
    _________ _______ ___ _______ ___ _____ ______ _______ _________.
    _______ ___ ______ ______ ________ _________.
    _____ ________ _________ _________ _________ ____ __________ ___ ___ __________.
    ____ _______ _____ _____ __________ ________ _______ ______ ______ ___ _________.
    ______ _______ __________ ______ ___.
    ______ ______ _____ ____ _________ ______ ________ ___ ________ _________ __________ ___.
    ______ ___ _____ ________ ______ _____ _____.
    ____ _________ ___ ________ ____ _________ _________.
    ___ __________ _______ _______ ________ _____ ___.
    _____ ________ _____ ___ __________ ________ _______.
    _____ ________ __________ _____ ___.
    _______ ______ ________ ___ ____ ____ ___ ______ ______ ______ _________ ________.
    ________ _____ __________ ________ __________ _________ _________ ______ ____ _______ ________.
    ___ ______ ___ ____ _________.
    ________ _________ __________ ____ _____ _______ ____ ____ __________ ________ ____.
    _______ _____ _____ __________ ____ __________ _________ ___.
    ________ ___ ______ ___ ________ ___ _______ _____ __________ ___.
    __________ ___ _______ _________ ____.
    ____ _____ ____ ____ ______ ______ ____ ____ ___ __________.
    _________ _____ ____ _________ ________ ______ ______ __________ _____ _____ __________.
    ________ _____ ____ ________ _______ _____ _______ _____ ___ __________ ___.
    __________ _______ ______ _____ ___ __________ ___ ______ ______.
    ______ _______ _____ _____ _________ ________ ________ ____ ___ _______ ________.
    ____ __________ _____ _____ ______ ________ __________ _____ _________.
    __________ ___ _________ __________ _____ _____ ________ ____.
    ___ _________ ____ ________ ________ ___ _________ _____.
    __________ ____ _____ ___ __________ ______ ________ ____.
    _____ ___ ______ ______ ____.
    _______ _________ __________ _____ ____ _________ ______ __________ __________.
    ____ __________ ___ ________ __________ ____ _________.
    ___ ___ _________ __________ ______ __________.
    ___ _________ _______ _____ _____ ______ ______ _________ ____.
    ________ ______ ___ ________ ___ _________.
    _____ __________ ____ ________ ____ ____ _______ _______.
    ________ _______ ____ _________ ________ ____ ______ _________ ____ _________.
    _______ ___ _______ ____ _________ ______ __________ ___ _________ _____ _________ ____.
    ___ __________ ____ ___ ______ __________ _________ ____ __________.
    ________ ______ ___ ___ ____ _____ ________.
    ____ _________ ____ ________ ______ _______ ______ _____.
    _____ _________ ________ ____ ________ ___.
    _________ ____ __________ ________ ________ _____ _________ __________.
    _____ _________ _________ ___ ____ ____ _____.
    _________ _______ ____ ________ ___ _______ ___ ____ __________ _________ ____ ____.
    ________ ________ ____ _________ _____ ______ ______ _________ _________ _____ ________.
    _______ _____ _________ _________ ___ _______ _______.
    _________ __________ ___ __________ ________ _____ _______ _________ ___ _____ ____.
    _______ ________ ________ _________ ________ _________ ______.
    ________ ___ _______ ________ ______ ______ ________ _______ ______ ____ _______ ______.
    _________ ______ ____ ___ ___ ____ _____ ______ ______ ______.
    ___ ___ _________ ___ ________ __________ ______.
    ________ _____ ____ ___ ___ _____ ________ __________ _____ _________ __________ ___.
    ____ ____ __________ _____ _____ __________ ____.
    _____ ____ ______ _____ __________.
    ________ _____ ________ _____ __________ _______ _____ _____ _____ ________.
    ____ ____ _________ _______ ___ ___ _______ __________ ______ _____ _______.
    ___ ___ ______ _____ ________ _____ ________ ___ ________ ________.
    ___ ______ __________ ______ __________ _____ ______ _______ _______ ___ _________.
    _________ __________ ________ ___ ___ ___ _______ _________ _____ _______ ____.
    _____ __________ ____ _________ _____ ____.
    __________ ___ ________ __________ ________ ____ __________.
    _____ ___ ___ ____ _______ ________ __________ ___ __________ ___ ____.
    ________ _________ __________ _______ ________.
    _____ ________ ________ __________ ________ _____ ______ _________ __________ _______ __________.
    ______ ______ _____ ______ ____ ___ __________ _____ ________ ________ _____ _____.
    ________ _________ ________ __________ ___ ___ _______ ________ ___ ____ ________ ____.
    ___ __________ _______ _____ ____ _________ ____ _________ ____ ____ ________ __________.
    _______ ____ _________ ___ ___.
    _____ _______ __________ ___ ________ ______ _____ _______ ________ ____ _____ __________.
    ___ __________ _______ _____ ________ __________ _______ ___ ___ _________ ______ _______.
    __________ _______ _____ _____ __________ _________ ___ _____ ________ __________ ___ ________.
    _______ __________ _______ ___ ________ __________ ______ _______ _________ __________ _____.
    __________ ___ ____ _______ ______ _________ ________ ________.
    ________ ______ _________ ________ _________ _________ _______ ____ _____ ___ ____.
    ______ ___ ________ _______ _____ ___ __________ ____.
    ________ ____ ___ _______ _____ ________ _____ ______ ____.
    ____ _______ _____ _______ _____ ___ ______ ____.
    ____ _____ ________ ______ ________.
    ___ _____ _____ ___ ____ ______ ______.
    ___ ___ ______ _________ _____ ___ ____ __________.
    __________ __________ _______ _____ ______ ________.
    _________ ________ ____ ________ ___ _______ __________ _____ ______ _________ ____.
    ____ __________ ______ ________ _____ _________ ________ ___.
    ___ _____ ________ ______ _____ ____ _____.
    __________ _________ ___ __________ __________ ______.
    ________ _________ _______ _______ ___.
    ________ __________ ________ ______ __________ _________ _____ _____ _____.
    __________ ______ ________ ___ _________ _______.
    ________ _____ ___ ____ _______ ___ _____ _______ _________ ______ __________.
    ___ _______ __________ __________ ________ __________ ________.
    _______ __________ ______ ____ ____ _________ __________ _________ ___ _________ ______.
    ______ _______ ___ ____ ________ _____ ______.
    ______ _________ __________ ______ __________ ____ _________.
    __________ ____ ________ _____ _______ ___ ___ ____ ________ ________ ________ ____.
    _______ ___ ________ ____ __________ ____ _____ ________ ____ _________.
    __________ ______ _________ ______ _________ ______ ________ _____ _________.
    ________ _______ _____ _________ ________ ____.
    _______ ____ __________ ______ ________ _______ _______ __________.
    ____ _____ ________ __________ ___ ____ ____ _______.
    ______ _____.
    Get Full Answer on WhatsApp

Related Questions

What is the difference between DDL and DML in DBMS?

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

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

Explain what is MS Power Point? List the different kinds of views available to format the slides.

IGNOU needs to send a letter to each student of the BPOI-007 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 personalised letter in Microsoft Word for each student so that each one feels the letter has been drafted for him or her alone?

Explain the advantages and disadvantages of blogging.

What is a secondary memory? Explain capacity, density and speed of hard disk drive.

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
→