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

In your database， all the tablespaces are locally managed. Y

题目
多选题
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

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

第1题：

Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database


参考答案：A, B

第2题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  • A、The database is in mount state.
  • B、One of the tablespaces is offline.
  • C、One of the tablespaces is read only.
  • D、The database operates in ARCHIEVELOG mode. 
  • E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第3题：

Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database


参考答案：A, B

第4题：

In which two cases would you perform only consistent backup？（）

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

第5题：

The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

  • A、 The Oracle database will not perform block checking for any of the data blocks.
  • B、 The Oracle database will perform block checking for the default permanent tablespace only. 
  • C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.
  • D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
  • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

正确答案:D

第6题：

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：  In what sequence would you use this process to perform the recovery？（）

  • A、7， 2， 3， 1， 4， 6， 5
  • B、7， 1， 3， 2， 6， 5， 4
  • C、2， 1， 7， 6， 3， 5， 4
  • D、2， 7， 3， 5， 1， 6， 4

正确答案:B

第7题：

Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

  • A、 The database does not record flashback logs for MY_TABLESPACE
  • B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
  • C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
  • D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

正确答案:A

第8题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database


参考答案：C, D

第9题：

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？（）

  • A、 2， 7， 3， 5， 1， 6， 4
  • B、 2， 1， 7， 6， 3， 5， 4
  • C、 7， 1， 3， 2， 6， 5， 4
  • D、 7， 2， 3， 1， 4， 6， 5

正确答案:C

第10题：

Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

  • A、 undo tablespace
  • B、 index tablespace
  • C、 read-only tablespace
  • D、 temporary tablespace

正确答案:D

更多相关问题
相关内容