What are the various locks available?

5 Answers   CTS,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

How does a cursor work?

0 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

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

3 Answers   Cap Gemini,

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

What are the advantages of using a PACKAGE?

2 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

How to execute stored procedures?

0 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---