This preview shows page 1. Sign up to view the full content.
Unformatted text preview: covery (or a recovery using a backup control file) and opened the database with the
To perform incomplete recovery, use the SET UNTIL command to specify the time,
Actualtests.com - The Power of Knowing 1Z0-042
SCN, restore point, or log sequence number at which recovery terminates. Alternatively,
specify the UNTIL clause on the RESTORE and RECOVER commands.
REF.: Oracle(r) Database 10g: New features for Oracle 8i, 18-21 and Oracle(r) 10g Backup and Recovery
You are unable to move the Unified Job Scheduler occupant from the SYSAUX
tablespace to the USERS tablespace. What could be the reason?
A. None of the SYSAUX occupants can be relocated.
B. The USERS tablespace is a bigfile tablespace (BFT).
C. The united Job Scheduler occupant cannot be relocated.
D. The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
A - Not true. Same off the occupants can be move
B - Not true. The USERS occupant , isn't , by default a BFT tablespace, and even tought,
you should be able to move anything to a BFT tablespace. The point it's about to move,
C - True answer, as you con check , by the following query :
SELECT occupant_name, move_procedure,
-------------- --------------------------------AO DBMS_AW.MOVE_AWMETA
JOB_SCHEDULER *** MOVE PROCEDURE NOT APPLICABLE **
ORDIM *** MOVE PROCEDURE NOT APPLICABLE ***
ORDIM/PLUGINS *** MOVE PROCEDURE NOT APPLICABLE ***
ORDIM/SQLMM *** MOVE PROCEDURE NOT APPLICABLE ***
STATSPACK Use export/import (see export parameter file spuexp.par)
D - Not true. Can move SYSAUX occupants, whem is possible, to any tablespace that
REF.: Metalink Note: 243246.1: 10G : SYSAUX Tablespace
QUESTION 90: Actualtests.com - The P...
View Full Document
- Fall '09