You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs

第1题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

• A、ALTER DATABASE FLASHBACK ON;
• B、GRANT SELECT any transaction TO scott;
• C、GRANT EXECUTE ON dbms_flashback TO scott;
• D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
• E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
• F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

第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？ （）

• A、SYSDATE should not be used with TIMESTAMP.
• B、The database must have multiplexed redo log files.
• C、The database must be in the MOUNT state to execute the command.
• D、The database must be opened with the RESETLOGS option after the flashback operation.
• E、The entire database needs to be restored from the most recent backup before the flashback operation.

第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？（）

• A、 Flashback logs are not deleted.
• B、 Flashback logs are deleted automatically.
• C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）
• D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
• E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

第4题：

Which three statements are true about Flashback Database?（）

• A、Flashback logs are written sequentially, and are archived.
• B、Flashback Database uses a restored control file to recover a database.
• C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F、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.

第5题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

• A、 ALTER DATABASE FLASHBACK ON
• B、 GRANT SELECT any transaction TO scott
• C、 GRANT EXECUTE ON dbms_flashback TO scott
• D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
• E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE
• F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

第6题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

• A、ALTER DATABASE FLASHBACK ON;
• B、GRANT SELECT any transaction TO scott;
• C、GRANT EXECUTE ON dbms_flashback TO scott;
• D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
• E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
• F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

第7题：

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$DATABASE
• B、 V$UNDOSTAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$FLASHBACK_DATABASE_STAT

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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_LOG
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$DATABASE
• D、 V$UNDOSTAT

第14题：

In which scenario do you use the Flashback Database feature？（）

• A、 when a table is dropped and you restore it from the Recycle Bin
• B、 when a user’s schema is dropped and you recover the user’s schema
• C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
• D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

第15题：

In which case would you use the Flashback Database feature to perform a recovery？（）

• A、to recover a dropped tablespace
• B、to recover data from a truncated table
• C、to recover a data file that has been shrunk
• D、to recover a database to the state that existed before the RESETLOGS operation

第16题：

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

• A、 To recover a dropped table.
• B、 To recover a dropped schema.
• C、 To recover data from a truncated table.
• D、 To view changes made by all the transactions during a given period of time.
• E、 To view changes made by a single transaction during a given period of time.

第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？（）

• A、 perform point-in-time recovery
• B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
• C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
• D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

第18题：

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?（）

• A、Only 1
• B、Only 2
• C、Only 3
• D、3 and 1
• E、1 and 2

第19题：

第20题：

第21题：

第22题：

第23题：