What are the prerequisites for performing flashback transactions? ()(Choose all that apply)
You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456; The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?()
The()writes the Flashback Database logs in the flash recovery area.
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?()
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()
Note the following statements that use flashback technology: 1. FLASHBACK TABLE ; 2. SELECT * FROM TO SCN AS OF SCN 123456; 3. FLASHBACK TABLE ; 5. SELECT * FROM TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?()
Exhibit, Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?`"= in the Flashback Database architecture.()
What two are the prerequisites for enabling Flashback Database?() (Choose two)
Flashback Database relies on which technologies to recover to a point in time?()
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this: 1. Set the retention target: SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; 2. Enable Flashback Database: SQL> ALTER DATABASE FLASHBACK ON; 3. Mount the database: SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance: SQL> SHUTDOWN IMMEDIATE 5. Open the database: SQL> ALTER DATABASE OPEN; Choose the correct sequence.()