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
答案解析:
因为TABLESPACE GROUP '' 后面为空,所以没有添加到任何组。
创建临时表空间

本文讨论了在数据库中创建新的临时表空间TEMP1的过程,并详细解释了如何通过指定TABLESPACE GROUP来控制该表空间所属的组。当未明确指定组名时,TEMP1将不会被添加到任何现有组中。
1万+

被折叠的 条评论
为什么被折叠?



