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
What does reorg do in db2?
What does db2 mean?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Explain in detail about buffer manager and its functionalities?
Define declaration generator (dclgen).
Is db2 free?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How can you count the number of rows from a table tab?
Can you use max on a char column?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is catalog database in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a bind in db2?
How to find the maximum value in a column in the db2 database?