How do you insert a record with a nullable column?

2 Answers  

---

What is the function of logging in the db2 database?

0 Answers  

---

What is DCLGEN ?

2 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

---

What is difference between rollback and commit?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

What is nvl in db2?

0 Answers  

---