Interested to Buy Any Domain ? << Click Here >> for more details...
What is a correlated sub query?
- 2 Answers
- 5587 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 1 No |
Give the COBOL definition of a VARCHAR field.
What are the different types of base tables?
How would the varchar column remarks defined?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
Are view updateable?
What is index in db2?
What is nvl in db2?
What is a buffer in memory?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is a subselect? Is it different from a nested select?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
COBOL 
