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