Which is the default permanent tablespace for all users…

You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

A.
USERS

B.
SYSTEM

C.
SYSAUX

D.
EXAMPLE

Explanation:
This table space is used to store permanent user objects and data. Like the TEMP table space, every database
should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be
created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is
assigned the default table space, and space for all objects created by non-system users comes from this table
space. For system users, the default permanent table space remains SYSTEM.



Leave a Reply 3

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