The database must have multiplexed redo logs for the flashback to succeed.
The database must be MOUNTED for the flashback to succeed.
The database must use block change tracking for the flashback to succeed.
The database must be opened in restricted mode for the flashback to succeed.
The database must be opened with the RESETLOGS option after the flashback is complete.
The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
第1题:
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? ()
第2题:
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
第3题:
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
第4题:
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
第5题:
These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT Name Null? Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()
第6题:
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?()
第7题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第8题:
BEGIN_TIME is the time at which Flashback logging is enabled.
END_TIME is the time at which the query is executed on the view.
REDO_DATA is the number of bytes of redo data written during the interval.
This view contains information about flashback data pertaining to the last 24 hours.
FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
第9题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第10题:
BEGIN_TIME is the time at which Flashback logging is enabled.
END_TIME is the time at which the query is executed on the view.
REDO_DATA is the number of bytes of redo data written during the interval.
This view contains information about flashback data pertaining to the last 24 hours.
FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
第11题:
SYSDATE should not be used with TIMESTAMP.
The database must have multiplexed redo log files.
The database must be in the MOUNT state to execute the command.
The database must be opened with the RESETLOGS option after the flashback operation.
The entire database needs to be restored from the most recent backup before the flashback operation.
第12题:
Flashback logs are not archived.
Flashback logs are maintained in redo log files.
Flashback logs are maintained in the Flash Recovery Area.
Flashback logs are used to maintain Flashback Database related errors.
Flashback logs need to be cleared manually after you disable Flashback Database.
第13题:
Which three statements are true about using flashback database in a multitenant container database(CDB)?()
第14题:
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
第15题:
These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null? Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? ()
第16题:
Which three statements are true about Flashback Database?()
第17题:
You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
第18题:
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?()
第19题:
Flashback logs are written sequentially, and are archived.
Flashback Database uses a restored control file to recover a database.
The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
Flashback Database can recover a database to the state that it was in before a reset logs operation.
Flashback Database can recover a data file that was dropped during the span of time of the flashback.
Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
第20题:
Flashback logs are not deleted.
Flashback logs are deleted automatically.
Flashback logs are deleted only if you are using Recovery Manager (RMAN)
Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
Flashback logs are deleted only if you are using Automatic Storage Management (ASM)
第21题:
Open the database in read-only mode.
Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
Enable the block change tracking feature.
Execute the ALTER DATABASE FLASHBACK ON statement.
第22题:
The root container can be flashed back without flashing back the pluggable databases (PDBs).
To enable flashback database, the CDB must be mounted.
Individual PDBs can be flashed back without flashing back the entire cdb.
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
第23题:
You have to shut down the database to perform the backups.
Archiving information is written to the data files and redo log files.
You can perform complete database backups without closing the database.
Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.