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
When reorg is used?
Is ibm db2 free?
What is db2 stogroup?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is alias in db2?
What happens in bind step in a db2 program?
What is a bind card?
What is the function of logging in the db2 database?
List some fields from sqlca?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What are foreign keys in db2?
Which isolation level provides maximum concurrency?
Is db2 a programming language?
If I have a view which is a join of two or more tables, can this view be updateable?
Is schema the same as database?