单项选择题
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)
相关考题
-
单项选择题
WhiletuningaSQLstatement,theSQLTuningAdvisorfindsanexistingSQLprofileforthestatementthathasstalestatisticsavailable.Whatwouldtheoptimizerdointhissituation?()
A. It updates the existing SQL profiles with current statistics
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually -
单项选择题
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()
A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. INSTANCE_TYPE -
单项选择题
WhichstatementaboutusingRMANstoredscriptsistrue?()
A. To create and execute an RMAN stored script,you must use a recovery catalog.
B. When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D. When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.
