How many types of page locks can be held in db2?

0 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

Compare a subselect to a join?

1 Answers  

---

How do I create a view in db2?

0 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

What is schema in db2?

0 Answers  

---

Can we insert update delete in view?

0 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---