Question

What is DDL and DML? Give examples of each?​

Answer 1

Explanation:

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

CREATE - to create a database and its objects like (table, index, views, store procedure, function, and triggers)

ALTER - alters the structure of the existing database

DROP - delete objects from the database

TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed

COMMENT - add comments to the data dictionary

RENAME - rename an object

DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE, etc., and it is used to store, modify, retrieve, delete and update data in a database.

SELECT - retrieve data from a database

INSERT - insert data into a table

UPDATE - updates existing data within a table

DELETE - Delete all records from a database table

MERGE - UPSERT operation (insert or update)

CALL - call a PL/SQL or Java subprogram

EXPLAIN PLAN - interpretation of the data access path

LOCK TABLE - concurrency Control

Answer 2

$\huge{\underline{\underline{\underline{\sf{\pink{ﾑɳรᏇɛƦ \: ࿐}}}}}}$

DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL. DML: DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.

$\boxed{\huge \star{{\mathfrak{\red{☠Hãrshü \: : hêrë☠}\star}}}}$