CMS专题

单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A Only the damaged or lost data files.B All of the data files of the database.C Only the data files belonging to the SYSTEM tablespace.D The data files be

题目
单选题
When performing an incomplete recover of the whole database， which data files must you restore？ （）
A

Only the damaged or lost data files.

B

All of the data files of the database.

C

Only the data files belonging to the SYSTEM tablespace.

D

The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第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题：

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 are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

  • A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
  • B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

正确答案:A

第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题：

When performing an incomplete recover of the whole database， which data files must you restore？ （）

  • A、Only the damaged or lost data files.
  • B、All of the data files of the database.
  • C、Only the data files belonging to the SYSTEM tablespace.
  • D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

正确答案:B

第6题：

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

第7题：

Which of the following commands cannot be executed when the database open？（）

  • A、RECOVER DATABASE
  • B、RECOVER TABLESPACE
  • C、RECOVER DATAFILE
  • D、ALTER DATABASE RECOVER DATAFILE

正确答案:B

第8题：

When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

  • A、Until SCN
  • B、Until time
  • C、Until cancel
  • D、Recover using backup control file.

正确答案:C

第9题：

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 option
  • B、open the database with the RESTRICTED option
  • C、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

正确答案:A,C

第10题：

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

更多相关问题
相关内容