Answer / deepak dada

amount of proccessing between two commit pts

what is consistency token

3 Answers  

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

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,

---

What are the three types of page locks that can be held?

1 Answers  

---

What are data types?

2 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

Which catalog table stores referential constraints?

1 Answers  

---