单项选择题

A. You cannot perform the TSPITR with the constraints e……

Youre 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 only be successful if the constraint is enabled.

<上一题目录下一题>

热门试题

单项选择题IfyouaregoingtorunaTSPITRrecovery，whichviewwillhelpyoutodeterminewhichobjectswillbelostduringtheTSPITR？（）

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

多项选择题Whichofthefollowingrestrictionsarenottruewithrespecttotablespacepoint-in-timerecovery？（）

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.

单项选择题When running the tablespace point-in-time command recover tablespace users until time ,,10 06 2008:22:42:00 auxiliary destination ,,c: oracle auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10 08 2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name USERS What is the likely cause of the error?（）

A. The database is in ARCHIVELOG mode.
B. There is not a current backup of the database available.
C. The USERS tablespace has dependent objects in other tablespaces and can not 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.

单项选择题youcanperformanactivedatabaseduplicationwhenthedatabaseisinNOARCHIVELOGmode.（）

A. True
B. False

单项选择题WhichcommandwouldcorrectlystartaTSPITRoftheUSERStablespace？（）

A. recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c\oracle\auxiliary
B. recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：\oracle\auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c\oracle\auxiliary
C. recover tablespace users to point-in.
D. recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：\oracle\auxiliary
E. recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：\oracle\auxiliary