Oracle Database 12c: Installation and Administration — Question 129

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

Answer options

• A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
• B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
• C. All the components may be moved into SYSAUX tablespace.
• D. All the components may be moved from the SYSAUX tablespace.

Correct answer: A, B

Explanation

Options A and B are correct because they accurately describe the functionality of the move procedures in relocating component data to and from the SYSAUX tablespace. Options C and D are incorrect as they imply that all components can be moved in or out of the SYSAUX tablespace, which is not supported by the procedures listed.