Flashback Database relies on which technologies to recover to a point in time?()
第1题:
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
第2题:
Your Oracle Database 10g is online when you execute the following statement: SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF; What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
第3题:
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?()
第4题:
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?()
第5题:
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? ()
第6题:
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()
第7题:
Which three actions are required to configure the Flashback Database?()
第8题:
set Flash Recovery Area
enable Flashback logging
create FLASHBACK tablespace
start the database in the ARCHIVELOG mode
start the database in the NOARCHIVELOG mode
第9题:
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.
第10题:
The database does not record flashback logs for MY_TABLESPACE
The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
第11题:
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.
第12题:
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
STARTUP MOUNT ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
第13题:
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
第14题:
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?()
第15题:
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
第16题:
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?()
第17题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第18题:
Which three statements are true about Flashback Database?()
第19题:
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
第20题:
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.
第21题:
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.
第22题:
V$DATABASE
V$FLASHBACK_DATABASE_STAT
V$FLASHBACK_DATABASE_LOG
V$RECOVERY_FILE_DEST
第23题:
DBWn
RECO
RVWR
LGWR
第24题:
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