Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

What are union and union all?

0 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

What is ALTER ?

3 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is the role of the data page in the db2 database?

0 Answers  

---

What is dbrm? When it will be created?

0 Answers  

---

What are the various locks available?

5 Answers   CTS,

---

What are the various isolation levels possible?

0 Answers  

---