📚 Practice Mode

Oracle Practice Test - 36

Learn at your own pace with hints and detailed explanations

1 / 19
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