Multiple choice

To avoid a large number of extents for big file tablespaces in very large databases, what does Oracle recommend?

  1. Use the AUTOALLOCATE clause for allocating new extents and set a very high extent size.

  2. Use the UNIFORM clause and simply let Oracle take care of the extent sizing.

  3. Use the UNIFORM clause for allocating new extents and set a very high extent size.

  4. Use the AUTOALLOCATE clause and simply let Oracle take care of the extent sizing.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Use the UNIFORM clause for allocating new extents and set a very high extent size.

Keep practicing — related questions