The boss says he doesn’t care if it’s extra work. He wants that information at the end of this week and if he likes it he’s going to want it every week. What is the best choice for this situation?
-
Derived Table
-
Volatile Table
-
Global Temporary Table
-
None of the above
C
Correct answer
Explanation
Global temporary tables persist across sessions for the same user, making them reusable for recurring weekly reports. Unlike derived tables (query-scoped) or volatile tables (session-only), GTTs remain available for repeated execution with the same structure.