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

0 Answers  

---

What are db2 tables?

0 Answers  

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

What is a root page?

1 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

What is the difference between Primary key and unique index?

6 Answers  

---