Multiple choice technology programming languages

This query requires me to denormalize information in three different tables and then join the results. Fortunately, I only need to do it one time. What is the best choice for this situation?

  1. Global Temporary Table

  2. Derived Table

  3. Volatile Table

  4. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Derived tables (subqueries in FROM clause) are ideal for one-time transformations because they exist only during query execution. For a single denormalization task, creating temporary tables adds unnecessary overhead and object management.

Keep practicing — related questions