Database Reference
In-Depth Information
the RVWR process is started. The RVWR writes the Flashback Database logs in the
fast recovery area. FBDA is the Flashback Data Archive background process; the
remaining options are fictitious.
18. A, B, C. The DBA can use Flashback Database to recover to an SCN, a point in time,
or a named recovery point that is within the recovery window. Transaction ID and
Session ID will not help you recover using the Flashback Database feature.
19. A, C. When creating a Flashback Data Archive, you need to specify the tablespace
name and a retention period. The storage quota is optional. You add tables to an
archive after the archive is created, not as a prerequisite. You don't need to name a
default Flashback Data Archive.
20. C. Do nothing. Once the retention period has passed, rows will be automatically
removed from the Flashback Data Archive. Using TRUNCATE on a table that is archived
is not allowed. Dropping the archive will definitely clear the old records, but it will
also eliminate the ones you wanted to keep.
Chapter 9: Diagnosing the Database
and Managing Performance
1. A, C, D. FOREGROUND_DUMP_DEST is not a valid initialization parameter, so option B
is incorrect. DIAGNOSTIC_DEST is the new parameter that replaces the parameters in
options A, C, and D, so E is incorrect.
2. B. When $ORACLE_BASE is set, it is the default value for DIAGNOSTIC_DEST .
3. C. Option A is incorrect because the correct order is diag/rdbms . Option B is incorrect
because the correct order is <dbname>/<instname> .
4. A, E. Options B, C, and D are each fundamental tasks of the Support Workbench
problem-resolution process.
5. B. Option A is incorrect because IPS does not delete files not associated with a package
that will be sent to Oracle Support. Option C is incorrect because IPS does not open an
Oracle service request for each critical error. D is incorrect because IPS does not dis-
play critical errors on the database home page.
6. D. All other sequences are incorrect. D is the correct sequence. First, create the new
package; then view the package contents. Next, view the manifest; then schedule the
job to upload the data for the incident to Oracle Support.
Search WWH ::




Custom Search