This winter holiday season, give a precious gift to your career by upgrading your skills. | Get Flat 15 - 20% OFF on All Courses | Save Today

[iqquestion id=21]

8 thoughts on “Database : Database Operations Discussion 2

  • karim

    DDL is Data Definition Language.
    DML is Data Management Language.
    DCL is Data Control Language.

  • Pamela halbhavi

    Data Definition Language(Is the subset of SQL commands that change object definitions within the data dictionary) -for eg Create, Alter, Drop commands in Oracle
    Data Manipulation Language(is a subset of DQl Commands that is used to change the data) – for eg Insert, Update, Delete commands in Oracle
    Data Control Language(subset of SQL Command that control the access permisisions) – for eg Grant and Revoke commands in Oracle

  • nasir

    DDL (Date Definition Language or Data Description – is a vocabulary used to define data structures in SQL. Use these statements to create, alter, or drop data structures in an instance of SQL Server.
    DML (Date Manipulation Language) – is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data.
    DCL (Date Control Language) – A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database. Examples of DCL commands include: GRANT to allow specified users to perform specified tasks.

  • Palwinder

    DDL is Data Definition Language.
    DML is Data Management Language.
    DCL is Data Control Language.

  • collins

    ddl – ddata defination language
    dml- data mangement language
    dcl- data control langugae

  • Olubunmi Ogunsola

    DDL i data definition language – can be used to create or alter
    DML is data management language – it is a method to manipulate tables like insert, update
    DCL is data control language – it enables or disables access by using syntax such as grant or revoke
    – Tomiwa

  • sivi ramesh

    DDL:Data definition Language
    Create, Alter, Drop, Truncate, Comment, Rename.
    DML:
    Data manipulation Laguage:
    Select, insert, update, delete
    Data Control Language:
    Grant , Revoke.

  • Bindu

    DDL means DAta Definition Language.
    DDL commands are :

    Create -Used to create a new database table

    Alter – To modify an existing table by adding or deleting fields, or updating their field size etc.

    Drop – To delete a table permanently with structure of the table also being deleted permanently.

    Truncate – will delete the column(s) from the table permanently

    DML – Data Modification Language
    This is used to perform the various operations on the data within the table.

    These are called CRUD operations.

    Insert – Creates a record in a table.

    Update – Updates an existing table with new values.

    Delete – Deletes a record in a table based on a certain criteria to identify the record.

    Select – To Read the data in the table and retrieve list of records matching a certain criteria which can help in reporting the data thus retrieved.

    DCL – Data control Language – These commands help the Administrator to control the access for each database user.

    Grant – willgive permissions for the user to access a database table.

    Revoke – will remove the accessibility permissions for the user.

Leave a Reply