Answer / s

You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.

What is a data page?

1 Answers  

---

What is difference between alias and synonym in db2?

0 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

What is an instance database?

0 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

Explain an outer join?

1 Answers  

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---