What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

what is rebinding ?

1 Answers   IBM,

---

What is the function of buffer manager?

1 Answers  

---

Is db2 a programming language?

0 Answers  

---

Where do you specify them?

0 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

What is cascading rollback?

0 Answers  

---

Why do we use cursor?

0 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

What is UNION,UNION ALL?

2 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---