what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

Why do we use cursor?

0 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

how can u understand the end of the table ?

1 Answers   TCS,

---

What are the three lock types?

2 Answers  

---

---

When would you prefer to use VARCHAR?

3 Answers  

---

How to take backup of table in db2?

0 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

Are views updatable ?

4 Answers  

---

What are column-name qualifiers used?

1 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

explain about index with examples

2 Answers   Syntel,

---