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 |
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is a thread?
What is null indicator in db2?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is dbrm? When it will be created?
How do I start db2 in windows?
What do the initials DDL and DML stand for and what is their meaning?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE