Exam 1z0-084 topic 1 question 22 discussion

Actual exam question from Oracle's 1z0-084

Question #: 22
Topic #: 1

[All 1z0-084 Questions]

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

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.

Show Suggested Answer

Suggested Answer: AE 🗳️

by krwi1 at March 18, 2025, 7:22 a.m.

Comments

Submit Cancel

217972f

6 days, 15 hours ago

Selected Answer: CE

E is correct as Oracle said here: " Using a tablespace group, rather than a single temporary tablespace, can alleviate problems caused where one tablespace is inadequate to hold the results of a sort, particularly on a table that has many partitions." https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tablespaces.html#GUID-A90A82C7-E06D-416F-842E-704A95FF2AB5

upvoted 1 times

...

krwi1

3 months, 4 weeks ago

Selected Answer: AC

E is wrong - the temp group is not a solution for lack of space

upvoted 1 times

...