Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）

相似题目

• The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)

  A . Control files B . Password files C . Inactive online redo log file D . Archived log files required to perform recovery E . Newly created tablespace which is not backed u

  查看最佳答案

• You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? （）

  A . Its entries are specific to a single database. B . It contains file systems that have been mounted by Direct NFS. C . It is globally available to all Oracle 11g databases on the machine. D . It contains file systems that have been mounted by the kernel NFS system.

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database 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 configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）

  A .  backup pieces B .  copies of all the parameter files C .  trace file generated using BACKUP CONTROLFILE TO TRACE D .  control file autobacku

  查看最佳答案

• You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）

  A . NOCHECKSUM B . MAXCORRUPT C . CHECK LOGICAL D . BACKUP INCREMENTAL E . CONFIGURE DEVICE TYPE ... PARALLELISM

  查看最佳答案

• You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）

  A .  DB_CREATE_FILE_DEST B .  DB_RECOVERY_FILE_DEST C .  DB_RECOVERY_FILE_DEST_SIZE D .  DB_ONLINE_LOG_DEST_

  查看最佳答案

• The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）

  A .  Control files B .  Password files C .  Inactive online redo log file D .  Archived log files required to perform recovery E .  Newly created tablespace which is not backed u

  查看最佳答案

• Identify the two situations in which you use the alert log file in your database to check the details.（）

  A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."  E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

  查看最佳答案

• You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

  A . backup pieces B . control file autobackups C . copies of all the parameter files D . trace file generated using BACKUP CONTROLFILE TO TRACE

  查看最佳答案

• In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

  A . After the COPY command. B . After adding a data file in the target database. C . After adding a tablespace in the target database. D . After adding a tablespace in the catalog database. E . After dropping a data file in the catalog database. F . After running SQL Loader to load a large amount of data.

  查看最佳答案

• In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

  A . a tablespace is taken offline B . the database instance is restarted C . a new data file is added to an existing tablespace D . a successful backup is recorded in the RMAN repository E . the RMAN connection is disconnected from the target database

  查看最佳答案

• The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

  A . Restore the data file and perform incomplete recovery. B . Restore the data file and perform point-in-time recover. C . Drop the tablespace and lose all data in the tablespace. D . Restore the database and lose all data since the last backup.

  查看最佳答案

• Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

  A . adding a new user to the database B . dropping a user from the database C . dropping a table from the database D . dropping a data file from a tablespace E . adding a new tablespace to the database

  查看最佳答案

• In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

  A .  A tablespace is taken offline. B .  The database instance is restarted. C .  A new data file is added to an existing tablespace. D .  A successful backup is recorded in the RMAN repository. E .  The RMAN connection is disconnected from the target database.

  查看最佳答案

• You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）

  A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

  查看最佳答案

• You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file？（））  

  A .  Its entries are specific to a single database. B .  It contains file systems that have been mounted by Direct NFS. C .  It is globally available to all Oracle 11g databases on the machine. D .  It contains file systems that have been mounted by the kernel NFS system.

  查看最佳答案

• 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 need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

  A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

  查看最佳答案

• You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）

  A . It records the usernames and passwords of users when granted the DBA role. B . It contains the usernames and passwords of users for whom auditing is enabled. C . Is used by Oracle to authenticate users for remote database administration. D . It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups. E . It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

  查看最佳答案

• You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

  A .  Restore the lost data file from the backup， and then flash back the database. B .  Restore the data file pertaining to index tablespace， and then recover the tablespace. C .  Restore all the data files， and then perform an incomplete recovery to get the tablespace back. D .  Restore all the data files， and then perform an incomplete recovery using the backup control file. E .  Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

  查看最佳答案

• Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

  A . Data files B . Control files C . Parameter file D . Online redo log files E . Server parameter file

  查看最佳答案

• Identify the two situations in which the alert log file is updated with details. （）

  A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." E . Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.

  查看最佳答案

• In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

  A . the alert log file B . the core dump files C . the change tracking file D . the user session trace files E . the database audit trail files F . the background process trace file

  查看最佳答案

• You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' /> A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

  查看最佳答案