1Z0-062 · Question #125
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?
The correct answer is A. The procedure may be used for some components to relocate component data to the SYSAUX B. The procedure may be used for some components to relocate component data from 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.
How the community answered
(37 responses)- A92% (34)
- C3% (1)
- D5% (2)
Why each option
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.
For some components that have been relocated out of SYSAUX, the move procedure can be used to migrate their data back into the SYSAUX tablespace, restoring the default storage location for that component.
For some components currently stored in SYSAUX, the move procedure can be used to relocate their data to a different tablespace when SYSAUX is under space pressure or for administrative reorganization.
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.
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
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SYSAUX_OCCUPANTS.html
Topics
Community Discussion
No community discussion yet for this question.