What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

How do you stop a db2 database in linux?

0 Answers  

---

What is a cursor?

2 Answers  

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

When the like statement is used?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

Which components manage deadlocks in db2?

0 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

What is bind and rebind in db2?

0 Answers  

---

What is a synonym ?

2 Answers  

---

What is normalization and what are the five normal forms?

1 Answers  

---