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 |
Can a Db2 table data be retrived through JCL?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
wht displays the number of times a query modified ?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is a lock?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
Why might full image copies be faster to implement than an incremental image copy?
Explain about dbrm.
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is plan in cobol db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?