Multiple choice technology databases

Which of the following statement(s) is (are) true?

  1. a. CELL_PARTITION_LARGE_EXTENTS initialization parameter can be used to set the INITIAL storage parameter to a preferred value for all segments in a partitioned object

  2. b. This parameter is relevant only to LMT with AUTOALLOCATE option

  3. c. This parameter is relevant only to LMT with UNIFORM option

  4. d. This parameter does not impact non-partitioned object and has valid values as TRUE, ALWAYS and DEFAULT
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

The initialization parameter _CELL_PARTITION_LARGE_EXTENTS (often used in Exadata) changes default initial extents for partitioned tables/indexes to 8MB. It applies to Locally Managed Tablespaces (LMT) with AUTOALLOCATE, affects only partitions, and accepts TRUE, ALWAYS, and DEFAULT.

Keep practicing — related questions