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.
Explanation:
V$SYSAUX_OCCUPANTSdisplaysSYSAUXtablespace occupant information.
MOVE_PROCEDURE:Name of the move procedure; null if not applicable
For example, the tables and indexes that were previously owned by the system user can now be
specified for a SYSAUX tablespace. You can query the v$sysaux_occupants view to find the exact
components stored within the SYSAUX tablespace.
B C not BD
Certainly not D, you cannot move ALL components out of sysaux.
And regarding the procedures mentioned IN the v$sysaux_occupants.move_procedure column, those components can all be moved IN the sysaux.
So it’s A and C.
A,B. Can move only some compononts into or out of the sysaux tablespace
A and B
ALL – where procedure exist ;/
A and B
“…if you later decide that the component should be relocated to a designated tablespace, you can use the move procedure for that component, as specified in the V$SYSAUX_OCCUPANTS view, to perform the move.
The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace…”
http://docs.oracle.com/cd/E16655_01/server.121/e17636/tspaces.htm#ADMIN11386
A and B
http://www.dba-oracle.com/t_v_sysaux_contents_tips.htm
I agree. correct answers are A and B. you can move only few components (not all) can be moved In/out of SYSAUX.
When you query from v$sysaux_occupants, you will see that some compenents don’t have move procedure so they can’t be moved away from SYSAUX.
AB
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
I’m not agree for me C and D
key is word “…procedures listed in…” i thing
AB
This is already available in 11g, not something new in 12c database
JanK is right, it’s C and D.
Not all the rows in v$sysaux_occupants.OCCUPANT_NAME have values in the column MOVE_PROCEDURE , but the ones that do have very clearly defined move procedures to move those components in and out of SYSAUX.
So, what is true about the use of the procedures that ARE listed? They can be used to move all the associated components in or out of SYSAUX.
AB
AB
AB
A & B:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces010.htm
AB
Isn’t it easier than all the above comments?
v$sysaux_occupants shows only the components that are in SYSAUX already so A and C are not applicable as they concern components that are NOT in SYSAUX.
Or am I being really short-sighted now?
A, B
Explanation: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces010.htm
-Also, if you later decide that the component should be relocated to a designated tablespace
-The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace.
A and B
http://orabase.org/index.php/exam-prepare/1z0-060-prepare/1z0-060-q3/
Not all procedures can be moved, AB is correct
Please stop by the sites we stick to, like this one, because it represents our picks in the web.
please stop by the internet sites we adhere to, including this one particular, because it represents our picks from the web
usually posts some very fascinating stuff like this. If you are new to this site
usually posts some extremely intriguing stuff like this. If youre new to this site
we prefer to honor lots of other internet internet sites on the web, even when they arent linked to us, by linking to them. Under are some webpages worth checking out
check beneath, are some absolutely unrelated internet websites to ours, on the other hand, they may be most trustworthy sources that we use
usually posts some incredibly intriguing stuff like this. If you are new to this site
A & B
The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace.
A and B
Jank is right please reread question carefully.
Example component JOB_SCHEDULER does not have anything listed on (move_procedure column) in (v$sysaux_occupants view).
Meaning there are no procedure to move it out from SYSAUX
Component LOGMNR have SYS.DBMS_LOGMNR_D.SET_TABLESPACE listed on move_procedure COLUMN.
Meaning if you want to move LOGMNR out/in you use sys.dbms_logmnr_d.set_tablespace procedure.
CD