CMS专题
单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL> RECOVER DATABASE 2 UNTIL TIME ’2004/x7f08/x7f05：12：10：03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be require
题目
A user table was lost at the specified time.
A redo log file was lost at the specified time.
The backup control file is on a faster disk than the current one.
The current control file has a different path compared with the intended time of recovery.
The current control file does not match the physical structure of the database at the intended time of recovery.
参考答案和解析
相似问题和答案
第1题：
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
第2题：
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）
- A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
- B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
- C、 The control file must be recreated.
- D、 The database must be opened with the RESETLOGS option.
正确答案:C
第3题：
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）
- A、 The log sequence for the database will restart from 1.
- B、 The log sequence number will be written to the control file.
- C、 The log sequence number will be written to the datafile headers.
- D、 The log sequence number will be written to the initialization parameter file.
正确答案:D
第4题：
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
- A、 by using the Flashback Database feature
- B、 by using RMAN incomplete recovery
- C、 by performing a user-managed incomplete recovery
- D、 by dropping and re-creating the index tablespace
正确答案:D
第5题：
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
- A、 online redo log files
- B、 alert log files
- C、 control file
- D、 datafiles associated with the SYSTEM tablespace
正确答案:C
第6题：
While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）
- A、Oracle Managed Files
- B、Oracle Grid Architecture
- C、Optimal Flexible Architecture
- D、Oracle database architecture
正确答案:C
第7题：
In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
- A、Oracle Migration Assistant
- B、Recovery Manager （RMAN）
- C、Oracle Data Pump Export and Import
- D、conventional Oracle Export and Import
- E、operating system utilities to copy the files to the ASM instance
正确答案:B
第8题：
You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）
- A、 A user table was lost at the specified time.
- B、 A redo log file was lost at the specified time.
- C、 The backup control file is on a faster disk than the current one.
- D、 The current control file has a different path compared with the intended time of recovery.
- E、 The current control file does not match the physical structure of the database at the intended time of recovery.
正确答案:E
第9题：
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
第10题：
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