Interested to Buy Any Domain ? << Click Here >> for more details...
What do the initials DDL and DML stand for and what is
their meaning?
- 2 Answers
- 5485 Views
- I also Faced
- E-Mail Answers
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 db2 stogroup?
Is it possible to precompile if db2 goes down?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is with ur in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is access path in db2?
Explain dclgen.
How can you quickly find out the # of rows updated after an update statement?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
COBOL 
