which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

What is reorg and runstats in db2?

0 Answers  

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What is the maximum size of varchar data type in db2?

0 Answers  

---

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 are the various locking levels available?

3 Answers  

---

What is index cardinality?

3 Answers  

---

What is a buffer in memory?

0 Answers  

---

What are the rules for db2 programming?

0 Answers  

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---