Interested to Buy Any Domain ? << Click Here >> for more details...
How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 7473 Views
- I also Faced
- E-Mail Answers
Answer / s
For every qualifying row in the outer query the correlated
subquery is evaluated. The correlated subquery has
reference to atleast one column of the outer query.
Non-correlated subquery does not make any reference to the
other query. The subquery is only executed once and the
results are used by the outer query to find the qualifying
rows.
| Is This Answer Correct ? | 7 Yes | 1 No |
Which component is used to execute the sql statements?
how to take the back up of the DB2 table.
What is the use of db2 optimizer?
What is buffer pool in the db2 database?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What is the use of COMMAREA ?Minimum how much data we can pass from it?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is a bind card?
What is explain in db2?
Which catalog table stores referential constraints?
What is a clustering index?
What is package versioning? Please give an example.
COBOL 
