CMS专题
多选题In which three situations is incomplete recovery required？（）AAfter a shutdown abort.BWhen recovering to an SCN.CWhen recovering until a specific time.DWhen a required archived log is missing.
题目
After a shutdown abort.
When recovering to an SCN.
When recovering until a specific time.
When a required archived log is missing.
参考答案和解析
相似问题和答案
第1题：
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
第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题：
A. set Flash Recovery Area
B. enable Flashback logging
C. create FLASHBACK tablespace
D. start the database in the ARCHIVELOG mode
E. start the database in the NOARCHIVELOG mode
第4题：
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
- A、 user managed complete recovery
- B、 user managed incomplete recovery
- C、 RMAN-based complete recovery
- D、 RMAN-based incomplete recovery
正确答案:D
第5题：
Identify two situations in which you can use Data Recovery Advisor for recovery.（）
- A、 The user has dropped an important table that needs to be recovered.
- B、 The database files are corrupted when the database is open.
- C、 You are not able to start up the database instance because the required database files are missing.
- D、 The archived log files are missing for which backup is not available.
正确答案:B,C
第6题：
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）
- A、 Complete database recovery.
- B、 Incomplete database recovery.
- C、 Approximate database recovery.
- D、 Archived database recovery.
- E、 The database could not be recovered with RMAN.
正确答案:B
第7题：
In which scenario will you perform a user-managed incomplete recovery？（）
- A、 when a table is dropped and stored in the Recycle Bin
- B、when a table is dropped and purged from the Recycle Bin
- C、 when you are required to recover an existing table to its previous state
- D、 when you are required to view all the versions of a row of an existing table between a specific time period
正确答案:B
第8题：
A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.
第9题：
In which scenario will you perform an incomplete recovery？（）
- A、 when a table is dropped and stored in the Recycle Bin
- B、 when all the control files are deleted
- C、 when a member of a multiplexed redo log group is dropped
- D、 when you are required to recover a table to its previous state
正确答案: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