> > >

MySQL MCQs

Why would you use a common table expression (CTE)?

To define queries for later reuse for the duration of the current session

To create temporary tables that can be used to pre-select often-used result sets.

To calculate a new single value from a result set and return it to the query parser.

To break down complex queries and allow reuse within a query.

Answer

Correct Answer: To break down complex queries and allow reuse within a query.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it