Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

A

 Database datafiles

B

 Control files

C

 Archived redo logs

D

 Online redo logs

E

 Flashback logs

相关问题推荐

• 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 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

  查看答案

• 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

  查看答案

• The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?（）

  A、The Oracle database will perform block checking for the index blocks only

  B、The Oracle database will not perform block checking for any of the data blocks

  C、The Oracle database will perform block checking for the default permanent tablespace only

  D、The Oracle database will perform block checking for the data blocks in all user tablespaces

  E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

  查看答案