单选题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？（）AA
题目
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.
相似考题
更多“单选题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 ”相关问题
-
第1题：
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
- A、Start the instance and open the database， instance recovery automatically recoverscontrol files
- B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
- C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
- D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
- E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
正确答案:D -
第2题：
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）
- A、shut down and restart the instance
- B、add new tempfiles to the temporary tablespaces after recovery
- C、perform a media recovery and open the database with the RESETLOGS option
- D、perform a media recovery and bring the database to NOARCHIVELOG mode
正确答案:B,C -
第3题：
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
- A、 target database
- B、 auxiliary database
- C、 third-party database
- D、 recovery catalog database
正确答案:C -
第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 working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）
- A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
- B、 restore the entire database from the most recent backup and open it
- C、 recover the table by using the Flashback Table feature
- D、 perform point-in-time recovery to recover the table
正确答案:D -
第6题：
单选题You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）Ause the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
Brestore the entire database from the most recent backup and open it
Crecover the table by using the Flashback Table feature
Dperform point-in-time recovery to recover the table
正确答案： B解析： 暂无解析 -
第7题：
单选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A2， 7， 3， 5， 1， 6， 4
B2， 1， 7， 6， 3， 5， 4
C7， 1， 3， 2， 6， 5， 4
D7， 2， 3， 1， 4， 6， 5
正确答案： A解析： 暂无解析 -
第8题：
单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMAN>RESTORE DATABASE； RMAN>RECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQL>ALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）AThe USERS.DBF datafile is corrupted and cannot be restored by RMAN.
BThe USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
CThe USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
DThe USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
正确答案： C解析： 暂无解析 -
第9题：
单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database, instance recovery automatically recovers control files
BCreate a file based on the contents of the trace file and save it to the control file locations and start the database
CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.)
DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
正确答案： D解析： 暂无解析 -
第10题：
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol file
Ball datafiles
Cpassword file
Donline redo log file
Earchive redo log file
Fserver parameter file
Gonly the SYSTEM datafile
正确答案： C,D解析： 暂无解析 -
第11题：
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）Aby using the Flashback Table feature
Bby using the Flashback Database feature
Cby performing incomplete recovery using RMAN utility
Dby performing incomplete recovery using user-managed recovery
正确答案： C解析： 暂无解析 -
第12题：
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）AYou will need to open the database with the resetlogs command.
BAll you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
CYou will use the resetlogs version of the create controlfile command.
DYou will use the noresetlogs version of the create controlfile command.
EYou will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
正确答案： E解析： 暂无解析 -
第13题：
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
- A、cannot be used in RMAN
- B、by starting up the database again
- C、by using the CATALOG command of RMAN
- D、by using the RECOVER CATALOG command in RMAN
- E、by re-creating the target control file to rebuild the RMAN repository
正确答案:C -
第14题：
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 -
第15题：
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
- A、Start the instance and open the database, instance recovery automatically recovers control files
- B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
- C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
- D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
- E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
正确答案:D -
第16题：
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）
- A、 You will need to open the database with the resetlogs command.
- B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
- C、 You will use the resetlogs version of the create controlfile command.
- D、 You will use the noresetlogs version of the create controlfile command.
- E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
正确答案:D -
第17题：
单选题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？（）Aincomplete recovery
Bcomplete recovery
Crecovery using the Flashback Database feature
Drecovery using the export/import utility
正确答案： A解析： 暂无解析 -
第18题：
单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）Acannot be used in RMAN
Bby starting up the database again
Cby using the CATALOG command of RMAN
Dby using the RECOVER CATALOG command in RMAN
Eby re-creating the target control file to rebuild the RMAN repository
正确答案： C解析： 暂无解析 -
第19题：
单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）Arecovery cannot be performed because a backup was not performed after the last incomplete recovery
Brestore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
Crestore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
Drestore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
正确答案： A解析： 暂无解析 -
第20题：
单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database， instance recovery automatically recoverscontrol files
BCreate a file based on the contents of the trace file and save it to the control file locations and start the database
CRe-create the database （The recovery of the control file is not possible because you have lost all the control files.）
DStart the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
EStart the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
正确答案： C解析： 暂无解析 -
第21题：
单选题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 required？（）AA user table was lost at the specified time.
BA redo log file was lost at the specified time.
CThe backup control file is on a faster disk than the current one.
DThe current control file has a different path compared with the intended time of recovery.
EThe current control file does not match the physical structure of the database at the intended time of recovery.
正确答案： A解析： 暂无解析 -
第22题：
单选题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？（）AA user table was lost at the specified time.
BA redo log file was lost at the specified time.
CThe backup control file is on a faster disk than the current one.
DThe current control file has a different path compared with the intended time of recovery.
EThe current control file does not match the physical structure of the database at the intended time of recovery.
正确答案： A解析： 暂无解析 -
第23题：
单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）Atarget database
Bauxiliary database
Cthird-party database
Drecovery catalog database
正确答案： B解析： 暂无解析 -
第24题：
单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）Arecovery cannot be performed because a backup was not performed after the last incomplete recovery
Brestore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
Crestore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
Drestore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
正确答案： C解析： 暂无解析