多选题Which are the prerequisites for performing flashback transactions on your database？（）AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permission on the DBMS_FLASHBACK package must be granted to the user.
多选题
Which are the prerequisites for performing flashback transactions on your database？（）
A
Undo retention guarantee for the database must be configured.
B
Supplemental log must be enabled for the primary key.
C
Supplemental log must be enabled.
D
Execute permission on the DBMS_FLASHBACK package must be granted to the user.
参考解析
解析：
暂无解析
相关考题：
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
Which two are prerequisites for performing a flashback transaction?() A. Flashback Database must be enabled.B. Undo retention guarantee for the database must be configured.C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D. Supplemental logging must be enabled.E. Recycle bin must be enabled for the database.F. Block change tracking must be enabled tor the database.
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A、 DBWnB、 RECOC、 RVWRD、 LGWR
Flashback Database relies on which technologies to recover to a point in time？（） A、 Flashback Data ArchiveB、 Flashback logs in the flash recovery areaC、 FlashbUndo tablespaceD、 RMAN command lineE、 None of the above
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）A、RMAN onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query
You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）A、 RESETLOGSB、 TO TIMESTAMPC、 TO BEFORE DROPD、 RENAME TOE、 TO SCN
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload
What are the prerequisites for performing flashback transactions? （）(Choose all that apply)A、Supplemental log must be enabledB、Supplemental log must be enabled for the primary keyC、Undo retention guarantee for the database must be configuredD、”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user
Which of the following Oracle features utilize the undo tablespace？（） A、 Flashback QueryB、 Flashback DropC、 Flashback TableD、 Flashback DatabaseE、 Transaction ProcessingF、 Recycle Bin
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？ （）A、 BEGIN_TIME is the time at which Flashback logging is enabled.B、 END_TIME is the time at which the query is executed on the view.C、 REDO_DATA is the number of bytes of redo data written during the interval.D、 This view contains information about flashback data pertaining to the last 24 hours.E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
Which two statements about Flashback Query are true？（）A、It is generated by using the redo log files. B、It helps in row-level recovery from user errors.C、It can be performed to recover ALTER TABLE statements D、It fails when undo data pertaining to the transaction is overwritten.E、The database has to be opened with the resetlogs option after performing Flashback Query.
Which two are prerequisites for performing a flashback transaction?（）A、Flashback Database must be enabled.B、Undo retention guarantee for the database must be configured.C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D、Supplemental logging must be enabled.E、Recycle bin must be enabled for the database.F、Block change tracking must be enabled tor the database.
Which three actions are required to configure the Flashback Database？（） A、 set Flash Recovery AreaB、 enable Flashback loggingC、 create FLASHBACK tablespaceD、 start the database in the ARCHIVELOG modeE、 start the database in the NOARCHIVELOG mode
Which two are the prerequisites to enable Flashback Data Archive？（）A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A、 An SCN is never used to perform a Flashback Table recovery.B、 If a significant number of changes have been made to the table， row movement must be enabled.C、 The tablespace must be offline before performing a Flashback Table recovery.D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
多选题Which two statements about Flashback Query are true？（）AIt is generated by using the redo log files.BIt helps in row-level recovery from user errors.CIt can be performed to recover ALTER TABLE statementsDIt fails when undo data pertaining to the transaction is overwritten.EThe database has to be opened with the resetlogs option after performing Flashback Query.
单选题Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A An SCN is never used to perform a Flashback Table recovery.B If a significant number of changes have been made to the table， row movement must be enabled.C The tablespace must be offline before performing a Flashback Table recovery.D Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
多选题What are the prerequisites for performing flashback transactions? （）(Choose all that apply)ASupplemental log must be enabledBSupplemental log must be enabled for the primary keyCUndo retention guarantee for the database must be configuredD”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user
多选题Which three actions are required to configure the Flashback Database？（）Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode
多选题Which two are the prerequisites to enable Flashback Data Archive？（）ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
多选题Which two prerequisites are needed for performing workload capture and replay？（）AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload
多选题Which two are prerequisites for performing a flashback transaction?（）AFlashback Database must be enabled.BUndo retention guarantee for the database must be configured.CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.DSupplemental logging must be enabled.ERecycle bin must be enabled for the database.FBlock change tracking must be enabled tor the database.
多选题Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabled.EThe tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
多选题Which are the prerequisites for performing flashback transactions on your database？（）AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permission on the DBMS_FLASHBACK package must be granted to the user.
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A DBWnB RECOC RVWRD LGWR
多选题Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
多选题You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）ARESETLOGSBTO TIMESTAMPCTO BEFORE DROPDRENAME TOETO SCN