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 need of Network Security? Explain its different elements?

 

Draw the block diagram of a computer system and briefly explain the function of each of the main components.

Explain the advantages and disadvantages of blogging.

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.

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

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?

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
→