What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

What are the isolation levels possible ?

3 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

Explain correlated sub-queries.

0 Answers  

---

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

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

3 Answers   Cap Gemini,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

When do you specify the isolation level? How?

1 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

What is the function of buffer manager?

1 Answers  

---

What is meant by dclgen?

0 Answers  

---