How can you do the explain of a dynamic sql statement?

0 Answers  

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

What are the functions in DB2?

3 Answers   Satyam,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

Where do you specify them?

0 Answers  

---

What is cursor in dbms?

0 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

Which isolation level provides maximum concurrency?

0 Answers  

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---