Answer / guest

Correlated subquery process is an outside-inside-outside
subquery. For every row in the outer query the inner query
is evaluated and results passed to the outer query to
complete the final result row.

Answer / aditya

a query in which there is reference of inner query into
outer query and that of outer query into inner
query...means they can't run independently.

What is check constraint. Explain with example.

1 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1 Answers   IBM,

---

What is bind package and plan in db2?

1 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

What is the function of logging in the db2 database?

1 Answers  

---

What is the picture clause of null indicator variable?

1 Answers  

---

What is the max length of sqlca?

1 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1 Answers   IBM,

---