Multiple choice

The user Smith created the SALES HISTORY table. Smith wants to find out the following information about the SALES HISTORY table:

  1. The size of the initial extent allocated to the sales history data segment
  2. The total number of extents allocated to the sales history data segment

Which of the following data dictionary view(s) should Smith query for the required information?

  1. USER_EXTENTS

  2. USER_SEGMENTS

  3. USER_OBJECT_SIZE

  4. USER_OBJECT_SIZE and USER_EXTENTS
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

USER_SEGMENTS provides segment-level information including initial extent size (from INITIAL_EXTENT column) and can be joined with other views for extent counts. The view contains storage parameters for segments owned by the user. Option A (USER_EXTENTS) shows individual extents but not the initial extent allocation. Option C (USER_OBJECT_SIZE) does not exist as a standard view. Option D combines non-existent and insufficient views.

Keep practicing — related questions