nerdexam
Oracle

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.

Managing Database Storage Structures

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)
  • A
    92% (34)
  • C
    3% (1)
  • D
    5% (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.

AThe procedure may be used for some components to relocate component data to the SYSAUXCorrect

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.

BThe procedure may be used for some components to relocate component data from the SYSAUXCorrect

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.

CAll the components may be moved into SYSAUX tablespace.

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.

DAll the components may be moved from the SYSAUX tablespace.

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

#SYSAUX tablespace#database components#data relocation

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice