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.

Before you give the explain statement, what are the prerogatives?

1042

---

What is bind package and plan in db2?

1054

---

How do I delete a table in database?

1024

---

What is the role of schema in the db2 database?

1276

---

Comment whether the cursor is closed during commit or not.

1107

---

How to find the number of rows in a db2 table?

1120

---

What is host variable?

1061

---

Name the lockable units in DB2?

1129

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1197

---

What is bufferpool in db2?

1056

---

What is db2 plan table?

1052

---

Explain about mirror activator disk mirroring?

1013

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4317

---

On which levels locks can be applied?

1134

---

What does db2 blu stand for?

1167

---