When is the access path determined for dynamic SQL?

2 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

What is cascading rollback?

0 Answers  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

How do you check for a null value in a db2 column?

2 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

max number of columns in a db2 table?

6 Answers  

---

What is an instance 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,

---

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,

---

How can you count the number of rows from a table tab?

0 Answers  

---