1Z0-067 · Question #139
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?
The correct answer is A. USERS. 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…
Question
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?
Options
- AUSERS
- BSYSTEM
- CSYSAUX
- DEXAMPLE
How the community answered
(23 responses)- A83% (19)
- B9% (2)
- C4% (1)
- D4% (1)
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.
Topics
Community Discussion
No community discussion yet for this question.