1Z0-062 Question #125: Real Exam Question with Answer & Explanation

The correct answer is A: The procedure may be used for some components to relocate component data to the SYSAUX. The MOVE_PROCEDURE column in V$SYSAUX_OCCUPANTS lists procedures that can relocate component data either into or out of the SYSAUX tablespace, but not all components support both directions of movement.

Question

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

Options

AThe procedure may be used for some components to relocate component data to the SYSAUX
BThe procedure may be used for some components to relocate component data from the SYSAUX
CAll the components may be moved into SYSAUX tablespace.
DAll the components may be moved from the SYSAUX tablespace.

Explanation

The MOVE_PROCEDURE column in V$SYSAUX_OCCUPANTS lists procedures that can relocate component data either into or out of the SYSAUX tablespace, but not all components support both directions of movement.

Common mistakes.

C. Not all components listed in V$SYSAUX_OCCUPANTS can be moved into SYSAUX; some components may be mandatory residents of SYSAUX and the MOVE_PROCEDURE column may be null, indicating movement is not supported.
D. Not all components can be moved out of the SYSAUX tablespace; certain Oracle-managed components are permanently stored in SYSAUX and do not have a supported move procedure, so a null value in MOVE_PROCEDURE indicates the component cannot be relocated.

Concept tested. SYSAUX tablespace component relocation using V$SYSAUX_OCCUPANTS

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SYSAUX_OCCUPANTS.html

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice