Oracle Database 12c: Installation and Administration — Question 103

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.
Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

Answer options

• A. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)
• B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
• C. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM
• D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

Correct answer: D

Explanation

The correct answer is D because the AUTOALLOCATE option allows for variable extent sizes, which is necessary for storing segments with different size requirements. Option A specifies fixed sizes, option B is focused on autoextend without addressing extent size management, and option C enforces uniform extent sizes, which does not meet the requirement for variable sizes.