WorksheetsAdBase Quiz No 2
Total questions: 15
Worksheet time: 8mins
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
Returns true if all of the subquery values meet the condition.
ANY
IN
FROM
ALL
Returns true if any of the subquery values satisfy the condition.
IN
ALL
FROM
ANY
It is used to select data from table referenced in the outer query.
Correlated Subquery
Correlation Table
Co-exists Subquery
IN Operator
Can CTE referenced within another SELECT, INSERT, Update and what?
DROP
INTO
UNION ALL
DELETE
Clauses like ORDER BY, INTO and _____________ cannot be uses in CTE queries.
OPTION
ALL
ANY
UNION ALL
