单项选择题
View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS.
You observe that the current default permanent tablespace of the database is
running out of space and you decide to change it to NEWDEFTBSP. You create a new user， USER04， after changing the default permanent tablespace of the database. What would be the new user’s default tablespace？（）
A.DEFTBSP
B.SYSTEM
C.NEWDEFTBSP
D.USERS and NEWDEFTBSP both
E.USERS
点击查看答案
相关考题
-
多项选择题
Identifythetwotablespaceswhosedatafilesaresocriticalthatonlyaclosedrecoveryispossible.（）
A.SYSAUX
B.TOOLS
C.UNDO
D.INDEX
E.SYSTEM
F.USERS
G.TEMP -
单项选择题
YouwanttosetuptheOracleDatabase10ginstallationtofollowtheFrenchlanguage，withFranceastheterritory，andthedatetobedisplayedinFrenchforallusers’sessions.Whichenvironmentalvariablewouldyousettoachievethisobjective？（）
A.NLSLANG
B.NLSLENGTHSEMANTICS
C.NLSTERRITORY
D.NLSLANGUAGE
E.NLSCHARACTERSET
F.NLSDATELANGUAGE
G.NLSNCHARCHARACTERSET -
单项选择题
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？（）
A.SYSTEM
B.USERS
C.PROD
D.SYSAUX
E.TEMP
