Compare a subselect to a join?

1 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

Explain db2.

0 Answers  

---

What is role in db2?

0 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

What are the various isolation levels possible?

0 Answers  

---

Explain about cursor stability?

0 Answers  

---

What is the error code -803 ?

3 Answers  

---

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 load utility in db2?

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---