The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to…

You created a database (using Database Configuration Assistant [DBCA]) by using one of the default templates. The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to ________.

You created a database (using Database Configuration Assistant [DBCA]) by using one of the default templates. The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to ________.

A.
USERS

B.
SYSTEM

C.
SYSAUX

D.
EXAMPLE

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *