You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）

A、 RMAN would use the current operating system location to place the backup.

B、 RMAN would use the control file of the target database to maintain the backup.

C、 RMAN would use the recovery catalog of the target database to maintain the backup.

D、 RMAN would use the control file of the target database to maintain the backup metadata.

E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

相关问题推荐

• You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

  A、 The archived redo logs are stored in an operating system-dependent location.

  B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

  C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

  D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

  查看答案

• Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  A、mount the new disk group in the ASM instance

  B、restart the ASM instance and the production database instance

  C、register the new disk groups in the production database instance

  D、restart the ASM instance without restarting the production database instance

  E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

  查看答案

• View the Exhibit and examine the Flashback SCNs.  A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery， you chose 2004343 as the Flashback SCN.  Which two statements are correct in this scenario？（）

  A

  Only the row with DEPARTMENT_ID 290 would be flashed back.

  B

  The rows with DEPARTMENT_ID 290 and 300 would be flashed back.

  C

  The rows with DEPARTMENT_ID 290 and 280 would be flashed back.

  D

  You would have taken the USERS tablespace offline before starting the Flashback Table operation.

  E

  You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.

  查看答案

• Exhibit，View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）

  A

   The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.

  B

   The members of SYS_GROUP would get most of the CPU allocation at level 1.

  C

   The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.

  D

   The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2.

  E

   The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.

  查看答案

• 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

  查看答案