SQL Quiz #3 - Table Expressions

Question 1 of 10

Which of the following cannot be used in a CTE query definition?

Question 2 of 10

Tables on remote servers can be referenced in a common table expression.

Question 3 of 10

Which of the following forms of table expressions are supported in T-SQL?

Question 4 of 10

Which of the following table expressions have the definition preserved in the database, as an object?

Question 5 of 10

All the columns returned by the inner query of a table expression must have unique names.

Question 6 of 10

Which of the following is a table expression that appears in the FROM clause of a query?

Question 7 of 10

Which of the following is not part of the structure of a common table expression (CTE)?

Question 8 of 10

You cannot refer to multiple instances of the same common table expression (CTE) in the outer query.

Question 9 of 10

For an inline table-valued function, here is no function_body delimited by BEGIN and END.

Question 10 of 10

What are the benefits of using a common table expression (CTE) over derived tables?

CTEs are better performing than derived tables.
Multiple instances of the same CTE can be referred in the outer query, avoiding duplicating code.
CTEs can be used by all the statements in the session, not only in the statement that defines them.
CTEs don't nest; the code is easier to follow and understand.

SQL Quiz #3 – Table Expressions