Affine Analytics Interview Questions | DDL, DML, and DCL commands

Question

SQL

in progress 0
TheDataMonk 55 years 2 Answers 1363 views Grand Master 0

Answers ( 2 )

  1. swap007
    0
    Reply

    DDL – Data Manipulation Language
    It deals with the structure of the database.
    Example – Create table, Alter table, Drop table

    DML – Data Manipulation Language
    It deals with manipulating the records stored in table.
    Example – Insert, Update, Delete

    DCL – Data Control Language
    It deals with granting and revoking database access permissions.

  2. Sai
    0
    Reply

    1)DDL- Data Definition Language
    It simply used to create and modify the structure of database objects in the database and descriptions of the database schema
    Examples: CREATE , DROP, ALTER, TRUNCATE
    2)DML- Data Manipulation Language
    It deals with the manipulation of data present in the database
    Examples: INSERT, UPDATE, DELETE
    3)DCL- Data Control Language
    It mainly deals with Rights, Permissions, and other control of the DataBase System.

Leave an answer

Browse
Browse