Answer Posted / s
Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is faster delete or truncate?
Define db2 and its databases?
How do I create a view in db2?
What is the syntax for creating a table in the db2 database?
what is a corelated subquerry?
Who uses db2?
Can one database have multiple instances?
What are the two types of logging in the db2 database? Explain them.
What are foreign keys in db2?
Explain how can you do the explain of a dynamic sql statement?
Highlight all the advantages that are attached to a package.
What is the difference between cursor stability and repeatable read isolation levels?
How do I add a column to a table in db2?
What is the difference between cursor and select statement?
Mention the downsides of page level lock.