Answer / ereshwari

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

What will the FREE command do to a plan?

2 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

Can we delete records from view?

0 Answers  

---

What is meant by AUTO COMMIT?

3 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

What is a plan and package in db2?

0 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---