Oracle Database Administration 2022 Certified Professional — Question 13

Which two statements are true about space usage in temporary tablespaces? (Choose two.)

Answer options

• A. When a global temporary table instantiation is too large to fit in memory, space is allocated in a temporary tablespace.
• B. Temporary tablespaces setting includes quotas to limit temporary space used by a session for that Temporary tablespace.
• C. A sort will fail if a sort to disk requires more disk space and no additional extent can be found/allocated in/for the sort segment.
• D. When a session consumes all temporary tablespace storage, then the session would hang until the temporary space used by that session is cleared
• E. Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.

Correct answer: A, E

Explanation

Option A is correct because it describes the behavior of global temporary tables when they exceed memory limits. Option E is also correct as using temporary tablespace groups can mitigate space issues for sorting. The other options either misrepresent the behavior related to temporary tablespaces or describe scenarios that are inaccurate.