Explain the contention situations caused by locks?

0 Answers  

---

What are the uses of db2 optimizer?

0 Answers  

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What is a buffer pool?

2 Answers  

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

What is view db2?

0 Answers  

---

What is innodb buffer pool?

0 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

What is meant by AUTO COMMIT?

3 Answers  

---