select 100 records from million records ?

2 Answers   Verizon,

---

Which isolation level provides maximum concurrency?

0 Answers  

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

---

What is meant by union and union all?

0 Answers  

---

Explain an outer join?

1 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

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

4 Answers   Syntel, UST,

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

Define sqlca.

0 Answers  

---