Enable flashback logging.
Start the database in the ARCHIVELOG mode.
Issue the ALTER DATABASE FLASHBACK ON; command.
Set the FAST_START_MTTR_TARGET initialization parameter.
第1题:
In order to perform Flashback Transaction Query operations, which of these steps are required?()
第2题:
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
第3题:
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()
第4题:
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently, several users are executing long-running queries on the database. What will happen to the ongoing activity in the database?()
第5题:
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file?()
第6题:
Which view will you use to view information regarding the jobs that are currently running in a database?()
第7题:
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
第8题:
You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()
第9题:
you can perform an active database duplication when the database is in NOARCHIVELOG mode.()
第10题:
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()