In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN RUN 2 { 3 ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4 BACKUP DATABASE; 5 } Which statement is true about the outcome?（）A、Only one channel is allocated and the backup is created in the flash recovery areaB、Only one channel is allocated and the backup is created in the destination specified for channel 1C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）
- A、Only one channel is allocated and the backup is created in the flash recovery area
- B、Only one channel is allocated and the backup is created in the destination specified for channel 1
- C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
- D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
相关考题：
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、 Flash back all the tables in the data file， one by one.B、 Restore the data file to a new location and perform a media recovery.C、 Flash back the database， there is no need to restore the data file.D、 Restore the data file from the most recent backup and flash the database.
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination. D Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up
单选题You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed.B The time when the first flashback operation in your database was performed.C A list of flashback operations performed in your database using SCN and time.D The approximate time and the lowest system change number （SCN） to which you can flash back your database.
单选题You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）AEnable the flash recovery area and specify it as the archived redo log destination.BDisable the flash recovery area and start the database instance in ARCHIVELOG mode.CEnable the flash recovery area but do not specify it as the archived redo log destination.DDisable the flash recovery area and start the database instance in NOARCHIVELOG mode.
多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch？（）AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
单选题A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A Flash back all the tables in the data file， one by one.B Restore the data file to a new location and perform a media recovery.C Flash back the database， there is no need to restore the data file.D Restore the data file from the most recent backup and flash the database.
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
单选题You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）A3 hoursB6 monthsCuntil last yearDuntil last commitEuntil the point when the undotablespacewas refreshedFuntil the database is shut down and the memory erased
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）ASet DB_FLASH_CACHE_SIZE=64GBSet D3_FLASH_CACHE_SIZE=64G, 64GCSet D3_FLASK_CACKE_SI2E=128GDdb_flash_cache_SI2E is automatically configured by the instance at startup
多选题You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）AChange the RMAN archived log deletion policyBUse the RMAN CROSSCHECK command to reclaim the archived log spaceCChange the RMAN retention policy to retain backups for a shorter period of timeDUse OS command to move files from the flash recovery area to some other location