50分提问ＯＣＡ解决方法

50分提问ＯＣＡ

159. View the Exhibit.
The DBA creates a new user as follows:
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;
User manfus creates a table as follows:
SQL> CREATE TABLE material (id NUMBER (3));
In which tablespace will the material table be created? 
   
 答案是：Ｃ，　我奇怪为什么不是Ａ，因为此时，USER manfus 被分配给了临时表空间？　
   
A) TEMP
B) PROD
C) USERS
D) SYSAUX
E) SYSTEM


------解决方案--------------------------------------------------------
因为建ACCOUNT时没有指定表空间,所以当创建表时会放在默认的表空间Users下面
http://space.itpub.net/7199859/viewspace-262946

引用楼主 ladamansuosi 的帖子:

159. View the Exhibit.
The DBA creates a new user as follows:
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;
User manfus creates a table as follows:
SQL> CREATE TABLE material (id NUMBER (3));
In which tablespace will the material table be created?

答案是：Ｃ，　我奇怪为什么不是Ａ，因为此时，USER manfus 被分配给了临时表空间？　

A) TEMP
B) PROD
…