违法和不良信息举报 联系客服
免费注册 登录

单选题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 

题目
单选题
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.

参考答案和解析
正确答案： B
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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 commit
  • B、Until the time you perform recovery
  • C、Until the time the date file got corrupted
  • D、Until the point where the last transaction begun
  • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

正确答案:A

第2题：

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 option
  • B、 open the database with the RESETLOGS option
  • C、 recover to the required SCN only that data file in which the error occurred
  • D、 recover all the data files to the same system change number （SCN）

正确答案:B,D

第3题：

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.

正确答案:A

第4题：

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 database
  • B、Create the data file and performtablespacerecovery
  • C、No need to restore any file， just recover the database
  • D、Restore only the system data file and recover the database
  • E、Restore only lost date file and performtablespacerecovery

正确答案:A

第5题：

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.

正确答案:A

第6题：

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. 

正确答案:C

第7题：

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 database
  • B、perform point-in-time recovery
  • C、perform a full database recovery
  • D、drop and re-create the tablespace
  • E、use Recovery Manager （RMAN） to recover the database

正确答案:D

第8题：

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.

正确答案:C

第9题：

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 commit
  • B、Until the time you perform recovery
  • C、Until the time the date file got corrupted
  • D、Until the point where the last transaction begun
  • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

正确答案:A

第10题：

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 open

  • A、 b， d， e
  • B、 b， d， f
  • C、 c， a， b， d， e
  • D、 c， a， b， d， f
  • E、 a， b， d， e

正确答案:A

更多相关问题
相关内容