How do I start db2 in windows?

0 Answers  

---

What is a lock?

1 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

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

1 Answers   CTS,

---

What are the various locks available?

5 Answers   CTS,

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

what is SPUFI ?

2 Answers  

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is deadlock?

2 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---