nerdexam
Oracle

1Z0-060 · Question #141

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 tablespace B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace. This question tests understanding of the MOVE_PROCEDURE column in V$SYSAUX_OCCUPANTS and its selective applicability for moving component data.

New Features for Manageability

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 tablespace
  • BThe procedure may be used for some components to relocate component data from the SYSAUX tablespace
  • CAll the components may be moved into SYSAUX tablespace.
  • DAll the components may be moved from the SYSAUX tablespace.

How the community answered

(28 responses)
  • A
    89% (25)
  • C
    4% (1)
  • D
    7% (2)

Why each option

This question tests understanding of the MOVE_PROCEDURE column in V$SYSAUX_OCCUPANTS and its selective applicability for moving component data.

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

For some components, the move_procedure column contains a callable procedure that can be used to relocate component data back into the SYSAUX tablespace after it has been moved out.

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

For some components, the move_procedure column contains a callable procedure that can be used to relocate component data out of the SYSAUX tablespace to a different tablespace, helping DBAs reclaim space.

CAll the components may be moved into SYSAUX tablespace.

Not all components can be moved into SYSAUX; some rows in V$SYSAUX_OCCUPANTS have a NULL move_procedure, indicating those components are permanently fixed in their current tablespace.

DAll the components may be moved from the SYSAUX tablespace.

Not all components can be moved out of SYSAUX; some components have a NULL or restricted move_procedure, meaning they must remain in SYSAUX and cannot be relocated.

Concept tested: V$SYSAUX_OCCUPANTS move_procedure for selective component relocation

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-sysaux-tablespace.html

Topics

#SYSAUX tablespace#v$sysaux_occupants#move_procedure#tablespace management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-060 Practice