Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9630 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 SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
List down the types of triggers in the db2 database?
What is cursor stability?
What are db2 tables?
What are the different types of base tables?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is the maximum No of rows per page?
How to compare data between two tables in db2?
What is index in db2?
What is ibm db2 used for?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What Utility is used to migrate DB2 from one release to the next?
COBOL 
