Skip to content

1z0-060 Q3

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

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.

answer

Answer A,B
C is wrong because not all component may be moved
D the same as C
explanation:
[code language=”sql” highlight=”5″]
17:49:58 (1)[Q2]c##bushmelev_aa@orcl> select count (*),move_procedure_desc from v$sysaux_occupants group by move_procedure_desc order by 1 desc;

COUNT(*) | MOVE_PROCEDURE_DESC
———- | ———————————————————————-
14 | *** MOVE PROCEDURE NOT APPLICABLE ***
4 | Move Procedure for Oracle Multimedia
2 | Move Procedure for Oracle Ultra Search
1 | Move Procedure for Oracle Spatial
1 | Move Procedure for Oracle Text
1 | Move Procedure for OLAP API History Tables
1 | Move Procedure for Enterprise Manager Repository
1 | Move Procedure for Logical Standby
1 | Move Procedure for XDB
1 | Move Procedure for Analytical Workspace Object Table
1 | Move Procedure for Workspace Manager
1 | Move Procedure for OLAP Catalog
1 | Move Procedure for LogMiner
1 | Use export/import (see export parameter file spuexp.par)
1 | Move Procedure for DB audit tables
[/code]

[свернуть]

Primary Sidebar