🎴 Flashcard Mode

Oracle Practice Test - 36

Card1 / 19
Mastered0
Review0
QuestionClick to flip

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?

AnswerClick to flip back
A
USER_SEGMENTS
💡 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.

Change Mode