KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 6613 Interview Questions


How does the processing of a correlated subquery differ from a non correlated subquery ? 

Posted in Database Interview Questions

The subquery in a correlated subquery is reevaluated for every row of the table or view named in the outer query, while the subquery of a non correlated  subquery is evaluated only once.

Post Your Answer!
Send This to a Friend

← What is correlated subquery ?
What is a result table ? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • What is the meaning of dynamic processing ?  11.08.08

    It's rarely used. It means one program uses both sequential and random processing for a VSAM KSDS file....

  • What is a view ?  23.07.08

    If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of securit...

  • What are the column name qualifiers ?  14.07.08

    A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...

  • What is correlated subquery ?  10.04.08

    A correlated subquery is one that has a correlation name as a table or view designator in the FROM clause of the outer query and the same correlation name as a...

  • What is subquery ?  10.04.08

    A subquery is a query that is written as part of another query’s WHERE clause. For example : SELECT    col_name1,col_name2 FROM       table_A WHER...

  • How do you define a correlated name?  09.04.08

    A correlated name  can be defined in the FROM clause of a query and in the first clause of an UPDATE or DELETE statement....

  • What are column-name qualifiers used ?  09.04.08

    Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. C...

  • What is an inner join, and an outer join ?  20.03.08

    Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table w...

  • What is backing bean  11.03.06

    A JavaBeans component that corresponds to a JSP page that includes JavaServer Faces components. The backing bean defines properties for the components on the pa...

  • What do you mean by Correlated subquery?  08.03.06

    Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed...