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? ()A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.

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? ()

  • A、 Open the database in read-only mode.
  • B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
  • C、 Enable the block change tracking feature.
  • D、 Execute the ALTER DATABASE FLASHBACK ON statement.

相关考题:

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.

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()A、Flashback log filesB、Backups that have become obsoleteC、User managed backups of the data files and control filesD、Archived redo log files that have multiple copies in a different archive location and not backed up

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

Which two statements are true regarding the database in ARCHIVELOG mode?()A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required?()A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area (FRA) for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

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.

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area (FRA) for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

You are managing a single instance Oracle 10g database that utilizes the following parameters:  Which of the following set of commands must you execute to enable Flashback Database?()A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

You configured the Flash Recovery Area (FRA) for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy()A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up

Which three actions are required to configure the Flashback Database? ()A、set Flash Recovery AreaB、enable Flashback loggingC、create FLASHBACK tablespaceD、start the database in the ARCHIVELOG modeE、start the database in the NOARCHIVELOG mode

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()A、Multiplex all database files.B、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter

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 managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()A、Multiplex all database filesB、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter.

多选题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area (FRA) for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG 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 (FRA) for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy()Aflashback log filesBbackups that have become obsoleteCcopies of the data files and control filesDarchived redo log files that have multiple copies in a different archive location and not backed up

单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required?()A V$DATABASEB V$FLASHBACK_DATABASE_STATC V$FLASHBACK_DATABASE_LOGD V$RECOVERY_FILE_DEST

多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area (FRA) for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()AMultiplex all database filesBConfigure the Flash Recovery Area.CConfigure the database instance for ARCHIVELOG mode.DConfigure the FAST_START_MTTR_TARGET initialization parameter.

多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

单选题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 are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()AMultiplex all database files.BConfigure the Flash Recovery Area.CConfigure the database instance for ARCHIVELOG mode.DConfigure the FAST_START_MTTR_TARGET initialization parameter

单选题You are managing a single instance Oracle 10g database that utilizes the following parameters:  Which of the following set of commands must you execute to enable Flashback Database?()A  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;B  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;C  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;D  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.