What do the initials DDL and DML stand for and what is
their meaning?
Answers were Sorted based on User's Feedback
Answer / s
Data Definition Language CREATE, ALTER, DROP
Data Manipulation Language SELECT, INSERT, UPDATE, DELETE
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Which isolation level provides highest data integrity?
Explain dclgen.
What is the result of open cursor statement?
How does db2 sample database connect?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
Explain in brief how does db2 determine what lock-size to use?
What is the difference between plan and package in db2?
What is lock contention?
Which is faster delete or truncate?
What is release/acquire in bind?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
How do you Load a table ?? and what is Load replace ?