What does DML stand for and what are some examples of it?
- 3 Answers
- 9964 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 the SQL query to select, delete and get count of duplicate rows in DB2?
what is the difference between join and union?
What is cascading rollback?
How can you display the current date & current time ?
what are the max. & min. no. of partitions allowed in a partition tablespace?
Mention the various locks that are available in db2.
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Can you search give an array in the WHERE clause of a db2 query?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
How does DB2 use multiple table indexes?
Which catalog tables contain authorization information?
What is rebind in db2?
COBOL 
