What does DML stand for and what are some examples of it?
- 3 Answers
- 8686 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 |
what is Runstats? Whem will u choose to runatats?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What does runstats do in db2?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
If I have a view which is a join of two or more tables, can this view be updateable?
How is a typical DB2 batch program executed ?
What is db2 and what is the use of db2 optimizer?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How to resolve -818 sql code in DB2?
What are the various locking levels available?
What information can you find in SYSIBM.SYSLINKS table?
COBOL 
