AdBase Quiz No 2

It specifies a temporary named result set.

• CTEE

• CTE

• CDE

• CGE

It allows user to define tables that can be used in a particular query.

• WITH

• WHERE

• IN

• ANY

Type of CTE that is easier to understand.

• Recursion

• Non-Recursive

• Non-Recursion

• Recursive

Type of CTE that is useful when working with hierarchical data.

• Recursion

• Non-Recursive

• Recursive

• Non-Recursion

Allows user to match one item from any of those in the list.

• IN

• ANY

• WHERE

• FROM

Works a part of the row selection process.

• WHERE

• AS

• DECLARE

• FROM

Returns a temporary or virtual table. Also called inline view.

• WHERE

• ANY

• ALL

• FROM

Subquery that is nested in the list of another select statement.

• SELECT

• FROM

• WHERE

• IN

Allows user to match one item from any of those in the list.

• ALL

• ANY

• IN

• EXISTS

Used to check whether a subquery produce any rows of query results.

• EXISTS

• ALL

• Correlated

• FROM