OCP CBT Question 579

Please solve the following question.

You are administering an Oracle database. You notice that some complex queries are performing slowly due to contention on temporary segments, and you decide to implement a temporary tablespace group to distribute the load across multiple temporary tablespaces. Which statement accurately describes a characteristic or benefit of using temporary tablespace groups?

A temporary tablespace group can only contain one temporary tablespace.

When a user is assigned a temporary tablespace group, Oracle automatically assigns temporary segments to different tablespaces within the group in a round-robin fashion, alleviating contention.

Temporary tablespace groups are primarily used for storing undo information for temporary tables.

All temporary tablespaces within a group must be dictionary-managed.