Answer / s

Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.

Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.

Partitioned tablespace, only one table can be defined and
rows are spread across partitions.

What is access path in db2?

0 Answers  

---

Explain about rct.

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is a clustering index ?

3 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

---

What is lock escalation?

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

Are views updateable?

0 Answers  

---

Explain an outer join?

1 Answers  

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---