Database Reference
In-Depth Information
What is the likely cause of the error?
A.
The database is in ARCHIVELOG mode.
B.
There is no current backup of the database available.
C.
The
USERS
tablespace has dependent objects in other tablespaces and cannot be a
part of a TSPITR alone.
D.
The
USERS
tablespace is not eligible for TSPITR because it has invalid objects.
E.
The
RECOVER TABLESPACE
command is incorrect and generates the error.
13.
Which of the following restrictions are not true with respect to tablespace point-in-time
recovery? (Choose all that apply.)
A.
The target database must be in NOARCHIVELOG mode.
B.
No backup is required of the database before you perform a TSPITR.
C.
You must have all archived redo logs generated since the last backup up to the
point to which you want to restore the transport set.
D.
If you rename a tablespace, you can not perform a TSPITR to any point in time
before that rename operation occurred.
E.
If you have tables in
tablespace_1
that have associated constraints in
tablespace_2
, then you must transport both tablespaces.
14.
If you are going to run a TSPITR recovery, which view will help you to determine
which objects will be lost during the TSPITR?
A.
TS_OBJECTS_TO_BE_DROPPED
B.
TS_PTTR_OBJECT_DROPPED
C.
TS_PITR_OBJECTS_TO_BE_DROPPED
D.
TS_OBJECTS_DROPPED
E.
TS_DROPPED_OBJECTS
15.
You're performing tablespace point-in-time recovery on a tablespace called
USERS
. If an
object in that tablespace has a foreign key constraint owned by another object in the
INDEX_TBS
, which statement is true?
A.
You cannot perform the TSPITR with the constraints enabled.
B.
You must perform the TSPITR recovery of both tablespaces for it to be successful.
C.
You can perform TSPITR only on the
USERS
tablespace.
D.
RMAN will determine if the
INDEX_TBS
tablespace must also be duplicated and
will duplicate it automatically.
E.
The TSPITR will be successful only if the constraint is enabled.
Search WWH ::
Custom Search