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
Which command is used to connect to a database in DB2 ? Give the Syntax.
Highlight all the advantages that are attached to a package.
What are db2 tables?
How do you select a row using indexes in db2?
What is the maximum No of rows per page?
Explain packages.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is difference between rollback and commit?
What does sqlcabc has?
What is reorg and runstats in db2?
What is the role of the data page in the db2 database?
What does a deadlock mean in DB2?
How can record locking be achieved in those DB2 versions which do not support it?
Which isolation level provides highest data integrity?
What is release/acquire in bind?