Which command will result in a trace file being created with the create controlfile command contained in it？（）  

A、 alter database backup controlfile

B、 alter database backup controlfile to trace

C、 alter database controlfile backup

D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

E、 alter database begin controlfile backup

相关问题推荐

• 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

  查看答案

• In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)

  A

  partitioning recommendations

  B

  statistics collection recommendations

  C

  index creation recommendations

  D

  materialized view recommendations

  E

  materialized view log recommendations

  查看答案

• Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）  

  A

   Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.

  B

   The problem key is the same as the incident number.

  C

   The database sends an incident alert to the Oracle Enterprise Manager Database Home page.

  D

   Every problem has a problem key， which is a text string that describes the problem.

  E

   The database makes an entry into the alert log file when problems and incidents occur.

  查看答案

• You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） 

  A

   SYSTEM

  B

   SYSAUX

  C

   UNDO

  D

   USERS

  E

   TEMP

  F

   This restore is not possible

  查看答案

• Which two statements are true regarding hot patching？（）

  A

   It requires relinking of the Oracle binary.

  B

   It does not require database instance shutdown.

  C

   It can detect conflicts between two online patches.

  D

   It is available for installing all patches on all platforms. 

  E

   It works only in a single database instance environment.

  查看答案