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

Answer Posted / s

Data Definition Language CREATE, ALTER, DROP
Data Manipulation Language SELECT, INSERT, UPDATE, DELETE

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the various isolation levels possible?

606


What is cursor with hold option in db2?

612


How can the duplicate values be eliminated from db2 select?

622


What are the contents of dclgen?

652


What is explain in db2?

582






What does sqlcabc has?

627


What is a buffer in memory?

596


What is sqlca?

617


How is the value function used?

600


What is the cobol picture clause of the db2 data types date, time, timestamp?

611


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

639


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1624


How connect db2 database to datastage?

760


Which command is used to connect to a database in DB2 ? Give the Syntax.

599


Mention the different locking levels that are available in db2.

642