Answer / s

Create the Plan_table to holds the results of the explain.

What is a DB2 access path?

1 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

what is plan? is plan executable or package?

4 Answers  

---

What is meant by concurrency?

1 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

What is deadlock?

2 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

What is multi row fetch in db2?

0 Answers  

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---