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,

---

is there any restrictions for unions ?

4 Answers   Patni,

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

What are union and union all?

0 Answers  

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

What are the various locking levels available?

3 Answers  

---

What is bind plan?

0 Answers  

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---