单项选择题
Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.
Which option must you use to perform TSPITR and preserve the object？（）
A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）
D. Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
相关考题
-
多项选择题
Whichtwostatementsaretrueregardinghotpatching？（）
A. It requires relinking of the Oracle binary.
B. It does not require database instance shutdown.
C. It can detect conflicts between two online patches.
D. It is available for installing all patches on all platforms.
E. It works only in a single database instance environment. -
单项选择题
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days， you want to change the status of the database backup and you issued the following command： RMAN>CHANGE BACKUPSET 231 NOKEEP； What is the implication of this command？（）
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy. -
单项选择题
WhichstatementdescribestheinformationreturnedbytheDBMS_SPACE.SPACE_USAGEprocedureforLOBspaceusage？（）
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
