Answer Posted / palash ghosh

1)Primary key creates an implicit culstered index on a
table, unique key does not create any implicit index.
2)Columns defined as primary key does not allow null values,
where as columns defined as unique can allow null values.
3)A table can have just one primary key (can be a composite
key) where as there can be multiple unique columns (keys).
4)Primary key is a unique key with the above mentioned
features.

What is db2 instance?

1016

---

Can there be more than one cursor open for any program?

1123

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2278

---

Explain the contention situations caused by locks?

1013

---

How will you return the number of records in table?

880

---

Name the various locking levels available?

1035

---

What is package in db2 mainframe?

918

---

What is dclgen (declaration generator)?

1010

---

what is a corelated subquerry?

1063

---

What is db2 stogroup?

1095

---

What is load replace in db2?

936

---

How can deadlocks be resolved?

889

---

Name the lockable units in DB2?

1073

---

How can you count the number of rows from a table tab?

1040

---

What is the difference between oracle and db2?

1031

---