Answer Posted / sriram

Correlated subquery runs once for each row selected by the
outer query. It contains a reference to a value from the
row selected by the outer query.

Nested subquery runs only once for the entire nesting
(outer) query. It does not contain any reference to the
outer query row.

For example

Correlated Subquery:

select e1.empname e1.basicsal e1.deptno from emp e1 where
e1.basicsal (select max(basicsal) from emp e2 where
e2.deptno e1.deptno)

Nested Subquery:

select empname basicsal deptno from emp where (deptno
basicsal) in (select deptno max(basicsal) from emp group by
deptno)



Please let me know if I am wrong...............

What are the benefits of using the db2 database?

1222

---

Explain package in db2 and its advantages?

1204

---

What is the purpose of rollback and commit?

1188

---

Explain in brief how does db2 determine what lock-size to use?

1035

---

What is null in db2?

1018

---

How many types of page locks can be held in db2?

1036

---

Comment whether the cursor is closed during commit or not.

1096

---

Is ibm db2 free?

1003

---

How to view db2 table structure?

1012

---

What are the various data types available in db2?

1088

---

How would the varchar column remarks defined?

1086

---

What is the usage of open cursor command?

1100

---

What is cloudant database?

1093

---

What is a db2 package?

1048

---

List out the three types of page locks that can be held.

1146

---