Which three statements regarding the properties of a temporary tablespace group are correct? (Choose three)
A.
It is created explicitly.
B.
It has the same namespace as tablespaces.
C.
It contains at least one temporary tablespace.
D.
It can contain a maximum of 1024 tablespaces in it.
E.
It has to be removed manually after the last temporary tablespace is removed.
F.
It is created automatically when the first temporary tablespace is assigned to it.
Explanation:
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. A tablespace group enables parallel execution servers in a single parallel operation to use multiple temporary tablespaces.
A – see F
B – It shares the namespace of tablespaces, so its name cannot be the same as any tablespace.
C – It contains at least one tablespace. There is no explicit limit on the maximum number of tablespaces that are contained in a group.
D – see C
E – The group is deleted when the last temporary tablespace it contains is removed from it.
F – You do not explicitly create a tablespace group. Rather, it is created implicitly when you assign the first temporary tablespace to the group.
REF.: Oracle 10g Administrator Guide 8-11