Answer / s

You can use LOCK TABLE on any table. View is not a
physical object.

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 CHECK PENDING ?

5 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

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

0 Answers   MCN Solutions,

---

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

pls tell me abt the normalization five types....

2 Answers  

---