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…

The correct answer is A. 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…

Managing Storage

Question

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?

Options

AUSERS
BSYSTEM
CSYSAUX
DEXAMPLE
ESAMPLE

How the community answered

(56 responses)

A
80% (45)
B
2% (1)
C
2% (1)
D
5% (3)
E
11% (6)

Explanation

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

Topics

#DBCA#default tablespace#USERS tablespace#permanent tablespace

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice