What do the initials DDL and DML stand for and what is
their meaning?

Answer Posted / komal riaz

DDL(Data Definition Language) is used for the manipulation
of Tables in SQL. This involves three functions CREATE,ALTER
and DROP.
Whereas DML(Data Manipulation Language) is used for the
manipulation of data in the tables. This involves four basic
functions SELECT,INSERT,UPDATE,DELETE.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between alias and synonym in db2?

644


What is dpf in db2?

666


What type of database is db2?

525


What does db2 plan contain?

573


How to check sequence on a table in db2?

600






What is iseries database?

597


When reorg is used?

676


What is the difference between nvl and coalesce?

602


Mention some fields that are a part of sqlca.

603


What is phantom read in db2?

639


How do I import a csv file into db2?

560


How and when does the db2 enforces the unique key?

615


How to get the ddl of a table in db2?

679


What are the uses of db2 optimizer?

817


What is db2 stogroup?

675