Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9631 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you find out the # of rows updated after an update statement?
What is the maximum number of columns in a db2 table?
What is iseries database?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are the two types of logging in the db2 database? Explain them.
What are the benefits of using the db2 database?
How would the varchar column remarks defined?
What is release/acquire in bind?
What is the use of value function?
what is db2 restart?
When the like statement is used?
What is coalesce in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is an instance database?
What is collection in db2 bind?
