Q: 11
Which three statements are true about GLOBAL TEMPORARY TABLES?
Options
Discussion
Isn't C a bit of a trap here? Deletes on GTTs can be rolled back just like normal tables, so only B, D, and E line up with how Oracle handles temp tables. Anyone disagree?
Not F, E is correct. Rows in a GLOBAL TEMPORARY TABLE get wiped when the session ends.
Nah, it's not F. GTT space gets allocated as needed, not right at session start. The correct picks are B (truncate only affects your own session), D (definition shared), and E (rows deleted on session end).
Hmm, I'd pick B, D, F. I thought space for GLOBAL TEMPORARY TABLES is allocated when the session starts (F), and truncate only affects the current session (B). Not totally sure about E since I figured there might be cases where rows live until commit. If anyone thinks otherwise, let me know.
Had something like this in a mock test, went with B, D, E.
Be respectful. No spam.