CMS专题
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）A Only the SET
题目
Only the SET command must be within a RUN block.
All commands should be executed at the RMAN prompt.
All three commands must be within a single RUN block.
Only the RESTORE and RECOVER commands must be within a single RUN block.
相似问题和答案
第1题：
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
- A、 Enable the flash recovery area and specify it as the archived redo log destination.
- B、 Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
- C、 Enable the flash recovery area but do not specify it as the archived redo log destination.
- D、 Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
正确答案:A
第2题：
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）
- A、 UNTIL CANCEL
- B、 UNTIL SCN
- C、 UNTIL SEQUENCE
- D、 UNTIL TIME
正确答案:A
第3题：
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （）
A. A
B. B
C. C
D. D
第4题：
You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
- A、 incomplete recovery
- B、 complete recovery
- C、 recovery using the Flashback Database feature
- D、 recovery using the export/import utility
正确答案:A
第5题：
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）
- A、 UNTIL SEQUENCE
- B、 UNTIL SCN
- C、 UNTIL CHANGE
- D、 UNTIL CANCEL
正确答案:C,D
第6题：
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)
正确答案:A
第7题：
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）
- A、 Initiate an incomplete recovery operation using RMAN.
- B、 Copy the table from a development database.
- C、 Advise the user to rekey the data.
- D、 Perform a Flashback Drop operation.
- E、 Perform a Flashback Recovery operation.
正确答案:D
第8题：
You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）
- A、 Whole database
- B、 Tablespaces
- C、 Datafiles
- D、 Archive logs
- E、 Redo logs
正确答案:E
第9题：
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
- A、 Query the V$FLASHBACK_DATABASE_LOG view.
- B、 Query the V$FLASHBACK_DATABASE_STAT view.
- C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
- D、 Query the V$RECOVERY_FILE_DEST view.
正确答案:B
第10题：
You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）
- A、 MOUNT mode
- B、 RESTRICTED mode
- C、 OPEN mode
- D、 NOMOUNT mode
正确答案:A