You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

A

You must ensure that the SALES database is mounted or open.

B

You must restore a backup control file to perform a block media recovery.

C

You must take the tools01.dbf data file offline before you start a block media recovery.

D

You must put the database in NOARCHIVELOG mode to perform a block media recovery.

E

You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

相关问题推荐

• You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1 for a plan， PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN =>’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUMER_GROUP2 => ’pay_group1’，  GROUP2_CPU => 20）；  END；  Which three statements are true？ （）

  A

   SYS_GROUP gets 100% CPU resources at level 1.

  B

   FIN_GROUP1 gets 80% CPU resources at level 1.

  C

   FIN_GROUP1 gets 80% CPU resources at level 2.

  D

   PAY_GROUP1 gets 20% CPU resources at level 1.

  E

   PAY_GROUP1 gets 20% CPU resources at level 2.

  F

   OTHER_GROUP gets 100% CPU resources at level 1.

  G

   OTHER_GROUP gets 100% CPU resources at level 2.

  查看答案

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

  A、 Disable SQL tracing for the APPS tablespace.

  B、 Disable logging attributes for the APPS tablespace.

  C、 Modify the tablespace to be a dictionary-managed tablespace.

  D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.

  E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

  查看答案

• In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

  A、 when all the online redo log groups are multiplexed and one of the members of a group is missing

  B、 when all the online redo log groups are not multiplexed and one log group is missing

  C、 when all the control files are missing

  D、 when some important tables are deleted from the database and purged from the Recycle Bin

  查看答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.

  B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.

  C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.

  D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

  查看答案

• Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

  A、 The user must have been granted the DBA role.

  B、 The user must have been granted the switch privilege as a part of a role.

  C、 The user must have been granted the Resource Manager administrator privilege.

  D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

  查看答案