what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

What is the meaning of -805 SQL return code?

3 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 schema in db2?

0 Answers  

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

What do you mean by commit and rollback?

0 Answers  

---

Define db2.

0 Answers  

---

Is schema the same as database?

0 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---