You created a database with the Database Configuration Assistant (DBCA) by using one of the
default templates.
Which tablespace will be the default permanent tablespace for non-system users, excluding
DBSNMP and OUTLN?
A.
USERS
B.
SYSTEM
C.
SYSAUX
D.
EXAMPLE
E.
SAMPLE
Explanation:
USERS
This tablespace is used to store permanent user objects and data. Like the TEMP tablespace,
every database should have a tablespace for permanent user data that is assigned to users.
Otherwise, user objects will be created in the SYSTEM tablespace, which is not good practice. In
the preconfigured database, USERS is assigned the default tablespace, and space for all objects
created by non-system users comes from this tablespace. For system users, the default
permanent tablespace remains SYSTEM.
REF.: Oracle(r) 10g 2 Days DBA, 6-7