You connected to the database using the following conne……

单项选择题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

多项选择题Exhibit： View the Exhibit.  Your Oracle 10g database has 6 tablespaces in which：  -TEMP is the default temporary tablespace  -UNDOTBS1 is the default undo tablespace  -USERS is the default permanent tablespace  In this database， which two tablespaces can be made read only？（）

A.TEMP
B.PROD
C.USERS
D.SYSAUX
E.SYSTEM
F.UNDOTBS1