Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9553 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / deepak dada
data manipulation language eg select insert update delete
| Is This Answer Correct ? | 4 Yes | 0 No |
DML stands for Data Manipulation Language.This langage
enables the users to make manipulation operations on the
data present in the database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / srinivasa yadav
DML STANDS FOR DATA MANIPULATION LANGUAGE
THE COMMANDS IN DML ARE SELECT, INSERT, DELETE, UPDATE
EX:-SELECT
1) SELECT * FROM TABLENAME;
IT WILL RETRIVE ALL THE COLUMNS.
2) SELECT EMP_ID,EMP_HLDR_NAME,EMP_AMT FROM TABLENAME;
IT WILL RETRIVE ONLY PARTICULAR ROWS.
INSERT : - IT IS USED TO INSERT THE VALUES.
DELETE : - IT IS USED TO DELETE THE ROW.
UPDATE : - IT IS USED TO UPDATE THE ROW.
| Is This Answer Correct ? | 2 Yes | 0 No |
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is meant by the attachment facility?
What is the difference between CS and RR isolation levels?
When the like statement is used?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is meant by isolation level?
i want to maintain uniqueness on pdf without make lf??????????
What does a deadlock mean in DB2?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What does the REORG Utility do?
Can you define an Index if the table size less than 10 PAGES?
What is the purpose of the DSNC transaction ?
COBOL 
