OCP 1Z0 053 68

68.You have three temporary tablespace groups named G1, G2, and G3 in your database. You are 
creating a new temporary tablespace as follows: 
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE 
GROUP ''; 
Which statement regarding the above command is correct? 
A. It will create the tablespace TEMP1 in group G1. 
B. It will create the tablespace TEMP1 in group G3. 
C. It will not add the tablespace TEMP1 to any group. 
D. It will create the tablespace TEMP1 in the default group. 
Answer: C

http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN01103

Multiple Temporary Tablespaces: Using Tablespace Groups

A tablespace group enables a user to consume temporary space from multiple tablespaces. 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 tablespace group has the following characteristics:

• It contains at least one tablespace. There is no explicit limit on the maximum number of tablespaces that are contained in a group.

• It shares the namespace of tablespaces, so its name cannot be the same as any tablespace.

• You can specify a tablespace group name wherever a tablespace name would appear when you assign a default temporary tablespace for the database or a temporary tablespace for a user.

You do not explicitly create a tablespace group. Rather, it is created implicitly when you assign the first temporary tablespace to the group. The group is deleted when the last temporary tablespace it contains is removed from it.

The view DBA_TABLESPACE_GROUPS lists tablespace groups and their member tablespaces.

See Also:

Oracle Database Security Guide for more information about assigning a temporary tablespace or tablespace group to a user

...

You can remove a tablespace from a group as shown in the following statement:

ALTER TABLESPACE lmtemp3 TABLESPACE GROUP '';