What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media？（）  

A、 crosscheck

B、 list backup

C、 confirm

D、 resync

E、 backup validate

相关问题推荐

• Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）  

  A、 when ASM disk goes offline

  B、 when one or more ASM files are dropped

  C、 when some disks in a disk group are offline

  D、 when some disks in a failure group for a disk group are rebalancing

  查看答案

• The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）  

  A、 You should perform a log switch

  B、 You should make a backup of the database

  C、 You should switch the database to the NONARCHIVELOG mode

  D、 You should shut down the database instance and perform a complete database recovery

  查看答案

• A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）

  A、The transactions that use the disk group will halt.

  B、The mirroring of allocation units occurs within the CONTROLLER2 failure group.

  C、The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.

  D、The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

  查看答案

• Which three statements about performance analysis by SQL Performance Analyzer are true？（）

  A

   It detects changes in SQL execution plans.

  B

   It produces results that can be used to create the SQL plan baseline.

  C

   The importance of SQL statements is based on the size of the objects accessed.

  D

   It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

  E

   It shows only the overall impact on workload and not the net SQL impact on workload.

  查看答案

• Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)

  A

  Alert log file

  B

  Archived redo log files

  C

  Control file autobackups

  D

  Server Parameter file (SPFILE)

  E

  Recovery Manager (RMAN) backup piece

  查看答案