How does DB2 determine what lock-size to use?

2 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,

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

Give the name of some fields form sqlca.

0 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

can any one expalin check point with an example?

1 Answers  

---

Can one database have multiple instances?

0 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---