Adv- Special

What does CTE stand for?

• Common Table Expression

• Common Table Execution

• Common Table Extension

• Common Table Execution

Which clause cannot be used in CTE queries?

• ORDER BY

• INTO

• OPTION

• FROM

What are the types of CTE?

• Non-Recursive CTE and Recursive CTE

• Recursive CTE and Subqueries

• Non-Recursive CTE and Subqueries

• Recursive CTE and Views

What is the purpose of a Common Table Expression (CTE)?

• To specify a temporary named result set

• To define a permanent table

• To execute a stored procedure

• To create a view

Which operator is used to match one item from a list in a subquery?

• IN

• ALL

• ANY

• EXISTS

What is the purpose of a subquery?

• To execute a stored procedure

• To define a temporary table

• To specify a temporary named result set

• To join two tables

Which clause is used to create a view in SQL?

• CREATE VIEW

• ALTER VIEW

• DROP VIEW

• SELECT VIEW

What is the purpose of an index in a database?

• To speed up searches/queries

• To store large amounts of data

• To create a backup of the database

• To encrypt data

Which type of index does not allow duplicate values?

• Single-Column Index

• Unique Index

• Composite Index

• Clustered Index

What is the purpose of a correlated subquery?

• To execute a stored procedure

• To join two tables

• To select data from a table referenced in the outer query

• To create a temporary table