网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 command must be within a RUN block.
B
All commands should be executed at the RMAN prompt.
C
All three commands must be within a single RUN block.
D
Only the RESTORE and RECOVER commands must be within a single RUN block.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 command must be within a RUN block.B All commands should be executed at the RMAN prompt.C All three commands must be within a single RUN block.D Only the RESTORE and RECOVER commands must be within a single RUN block.” 相关考题
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（） A、 Restore and recover the datafile.B、 Restore and recover the tablespace.C、 Restore and recover the database.D、 Restore and recover the control file.E、 Restore and recover the parameter file.
考题
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 command must be within a RUN block.B、All commands should be executed at the RMAN prompt.C、All three commands must be within a single RUN block.D、Only the RESTORE and RECOVER commands must be within a single RUN block.
考题
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
考题
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
考题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number （SCN）
考题
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.
考题
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
考题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
考题
You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA、 b， d， eB、 b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 a， b， d， e
考题
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
考题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）A、open the database with the RESETLOGS optionB、open the database with the RESTRICTED optionC、recover all the data files to the same system change number （SCN）D、recover to the required SCN only that data file in which the error occurred
考题
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 SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A、 Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B、 The restore command will fail.C、 The recover command will fail.D、 The alter database open resetlogs command will fail.E、 All these commands will fail because they must be in the confines of a run block.
考题
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and perform tablespace recoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
考题
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）A、import the database from the last exportB、restore all the members in the group from the last backupC、drop the lost member from the database， and then add a new member to the groupD、restore all the database files from the backup， and then perform a complete recovery E、restore all the database files from the backup， and then perform an incomplete recovery
考题
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
考题
单选题You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A
Start the database in the MOUNT stage.B
Back up the control file to trace.C
Set the DBIDD
Issue the RECOVER DATABASE command.
考题
多选题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？（）AUNTIL SEQUENCEBUNTIL SCNCUNTIL CHANGEDUNTIL CANCEL
考题
单选题You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A
Restore all the data files and open the databaseB
Create the data file and perform tablespace recoveryC
No need to restore any file， just recover the databaseD
Restore only the system data file and recover the databaseE
Restore only lost date file and performtablespacerecovery
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A
Restore and recover the datafile. B
Restore and recover the tablespace. C
Restore and recover the database. D
Restore and recover the control file. E
Restore and recover the parameter file.
考题
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A
Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B
The restore command will fail.C
The recover command will fail.D
The alter database open resetlogs command will fail.E
All these commands will fail because they must be in the confines of a run block.
考题
单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A
8， 1， 3， 2， 4， 5， 7， 6B
1， 8， 3， 4， 2， 5， 7， 6C
1， 3， 4， 2， 8， 5， 6， 7D
1， 3， 2， 4， 6， 5， 7， 8
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）A
Restore and recover the datafile.B
Restore and recover the tablespace.C
Restore and recover the database.D
Restore and recover the control file.E
Restore and recover the parameter file.
考题
单选题You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA
b， d， eB
b， d， fC
c， a， b， d， eD
c， a， b， d， fE
a， b， d， e
考题
单选题You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A
NOMOUNTB
MOUNTC
OPEND
RESTRICTED
考题
单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A
You need to perform the restore and recover operations manually, because the backup was made manually. B
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
热门标签
最新试卷
