Multiple choice technology databases

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a user creates an object (table, index, etc.) without specifying a TABLESPACE clause, Oracle stores the segment in that user's default tablespace, as defined when the user was created or altered. The system tablespace is for data dictionary objects, and there is no concept of a 'default tablespace for system' in this context.

AI explanation

To answer this question, we need to understand how Oracle manages the storage of segments.

When a user creates an object (such as a table or index) without specifying a TABLESPACE clause, Oracle will store the segment in the default tablespace for the user.

Option A) System tablespace - This option is incorrect because the system tablespace is used to store the data dictionary and other system-related objects, not user-created segments.

Option B) Users tablespace - This option is incorrect because there is no specific "users" tablespace in Oracle. Each user has their own default tablespace, which is where the segment would be stored.

Option C) Default tablespace for the user - This option is correct because Oracle will store the segment in the default tablespace for the user who created the object.

Option D) Default tablespace for system - This option is incorrect because there is no specific "default tablespace for system" in Oracle. The default tablespace is specific to each user.

The correct answer is Option C) Default tablespace for the user. This option is correct because Oracle will store the segment in the default tablespace for the user who created the object.

Keep practicing — related questions