Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

Write a query to retrive partial string.

2 Answers  

---

What is lock escalation?

2 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

What is nvl in db2?

0 Answers  

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  

---

What is cursor with hold option in db2?

0 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

is it compulsory commitment control in journal?

0 Answers   TCS,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---