What does DML stand for and what are some examples of it?
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
Name the various locking levels available?
What does reorg do in db2?
define clustering index.
How can you classify the locks in db2?
Can you use max on a char column?
What is the syntax for creating a table in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a system catalog table in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is dbrm?
Can one database have multiple instances?
How to take backup of table in db2?
What is buffer pool and list some of them?
What is data manager?
What is db2 stogroup?