Database Reference
In-Depth Information
19.
A, B, C. Oracle Secure Backup (OSB) provides the ability to connect directly to ven-
dor tape devices without needing to use any vendor middleware libraries. When using
RMAN you still use the SBT libraries to connect to Oracle Secure Backup. OSB also
provides the ability to perform OS backups.
20.
A. The
LIST INCARNATION OF DATABASE
command is used to produce a report of
database incarnations.
Chapter 8: Understanding
Flashback Technology
1.
A, C, E. Flashback Drop utilizes the Recycle Bin, which does not use the undo tablespace;
therefore options B and F are incorrect. Flashback Database is a physical recovery method
and does not use undo; therefore option D is incorrect.
2.
B, D. The Recycle Bin is a logical container of Flashback dropped objects. The objects
in the Recycle Bin are stored in the tablespace they were created in.
3.
C. Flashback Transaction Query could provide the data requested in a single query.
Option A is an invalid choice because the table wasn't dropped. Option B is incorrect
because Flashback Query returns data at only a specific point in time, not for a range
of times. Option D is incorrect because, although it could produce the data needed for
the report, Flashback Version Query would have to be run for each table individually.
Option E is incorrect because the user does not want to recover the table at all.
4.
A. The user needs to have the
SELECT ANY TRANSACTION
privilege granted to him. All
of the other choices are incorrect.
5.
C. AUM will ignore the
UNDO_RETENTION
parameter if the undo tablespace is not set to
autoextend. Option A is incorrect because guaranteeing retention could result in failed
transactions, which you specifically want to avoid. Option B is not the best answer
because the size of the undo tablespace is not the cause of the issue, but increasing the
size of the undo tablespace could increase the amount of undo retained. Option D is
wrong because this question is not dealing with the Recycle Bin and because it has no
guaranteed retention setting.
6.
C, D. Version 10.0 or higher compatibility must be set, so option A is incorrect.
Option B is incorrect because there is no such thing as Flashback Logging. Option E
is incorrect because ARCHIVELOG mode has no effect on Flashback Transaction
Query functionality.
7.
A, E. The likely causes are that the
RETENTION GUARANTEE
option has been set on the
undo tablespace and there are no expired transactions to remove to make room for
Search WWH ::
Custom Search