Answer Posted / abirami

Sorry.. Answer 1 given by me is incorrect.

Correct Query is

select disntinct salary from tablename
Order by salary
Fetch first 10 rows only

What is reorg?

1165

---

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 ?...

4318

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1074

---

What is a db2 schema?

1241

---

What is buffer pool and list some of them?

1043

---

What kind of database is db2?

1038

---

What is the difference between db2 and oracle?

1135

---

Explain in detail about buffer manager and its functionalities?

1073

---

If I have a view which is a join of two or more tables, can this view be updateable?

1139

---

Define db2 and its databases?

1059

---

How do I add a column in db2?

1053

---

What is database manager in db2?

1027

---

What is the default page size of buffer pools?

1125

---

What is cursor in dbms?

1074

---

What is rebind in db2?

1073

---