A correlated subquery is where the outer query depends on data from the inner query.

Which of the following is a correlated subquery?

A

Uses the result of an inner query to determine the processing of an outer query

B

Uses the result of an outer query to determine the processing of an inner query

C

Uses the result of an inner query to determine the processing of an inner query

D

Uses the result of an outer query to determine the processing of an outer query

Which is not true of a correlated subquery?

A

EXISTS/NOT EXISTS is a form of a correlated subquery.

B

The processing of the SELECT statements is nested.

C

They can be used to verify functional dependencies.

D

They are very similar to a regular subquery.

Select the pair of correlated words/phrase to complete the sentence. There have been short periods in which the firm's market performance has-----radically, although the firm has registered strong---- in the last ten years.

A

augmentation----steadied

B

declined----growth

C

expansion---stagnated

D

extension---stabilized

Situation in which two or more independent variables are highly correlated is known as

A

price linearity

B

cost linearity

C

division linearity

D

multi-collinearity

Portfolio which consists of perfectly positive correlated assets having no effect of

A

negativity

B

positivity

C

correlation

D

diversification

A square is inscribed in a circle of diameter 2a and another square is circumscribing circle. The difference between the areas of outer and inner squares is:

A

a^2

B

2a^2

C

3a^2

D

4a^2

A square is inscribed in a circle of diameter 2a and another square is circumscribing circle. The difference between the areas of outer and inner squares is__

A

a2

B

2a2

C

3a2

D

4a2

A square is inscribed in a circle of diameter 2 a sand another square is circumscribing circle. The difference between the areas of outer and inner squares is.

A

a2

B

2a2

C

3a2

D

4a2

The error due to eccentricity of inner and outer axes can be eliminated by

A

reading both verniers and taking the mean of the two

B

taking both face observations and taking the mean of the two

C

double sighting

D

taking mean of several readings distributed over different portions of the graduated circle

The shearing stresses in the inner face as compared to outer face of the wire in a heavy close coiled spring is

A

Larger

B

Smaller

C

Equal

D

Larger/smaller depending on diameter of spring coil

A correlated subquery is where the outer query depends on data from the inner query.

Related Questions