🎴 Flashcard Mode
SQL Fundamentals and Database Concepts
Card1 / 20
Mastered0
Review0
QuestionClick to flip
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
AnswerClick to flip back
A
Default tablespace for the user
💡 Explanation:
When no TABLESPACE clause is specified, Oracle stores the segment in the user's default tablespace. This is assigned when the user is created and can be viewed with the DEFAULT_TABLESPACE column in DBA_USERS. The SYSTEM tablespace is reserved for data dictionary objects.