We’ve just been handed an ad-hoc request for information which will require us to run a bunch of queries against a summary of last year's sales figures. What is the best choice for this situation?
-
Derived Table
-
Volatile Table
-
Global Temp Table
-
All of the above
B
Correct answer
Explanation
Volatile tables are temporary session-specific tables ideal for ad-hoc queries. They exist only during the session and are automatically dropped, perfect for one-time analysis without cluttering the database. Derived tables are query-scoped, while global temp tables persist for future use.