Answer / durga

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely

union all : it would combine the two query and displays then
as its duplicates.

Answer / veki

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely AND OUTPUT IS SORTED
ACCORDING TO FIRST COLUMN OF QUERY1

union all : it would combine the two query and displays then
as its duplicates AND HERE NO SORTING IS DONE.

in ap_terms table what data will be stored

2 Answers   Wipro,

---

what is the use of anchors?

2 Answers   IBM,

---

what is the difference between credit memo and debit memo?...

2 Answers   Sony,

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

List the various types of value set.

0 Answers  

---

do i need to declare bind parameter before using in the query?

2 Answers   Satyam,

---

AOL?

4 Answers  

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---

what is latest version in reports

8 Answers  

---

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,

---

what is trace file? what is the use of that?

4 Answers  

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---