What can the SET option of the Repair Utility accomplish?

1 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 sqlcode -922 ?

2 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is db2 catalog database?

0 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What is the physical storage length of timestamp data type?

0 Answers  

---

Can I use LOCK TABLE on a view?

1 Answers  

---

What is a result table?

1 Answers  

---