多选题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 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.
参考解析
解析：
暂无解析
相关考题：
What two are the prerequisites for enabling Flashback Database?() A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT stateE. The database instance must have the keep buffer pool defined
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 two CIFS commands are accelerated by AppFlow? ()(Choose two.) A. ReadXB. Write AndXC. Trans2 QueryD. Tree Disconnect
Which of the following statements best describes Flashback Versions Query？（） A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
Which two CIFS commands are accelerated by AppFlow? （）(Choose two.)A、ReadXB、Write AndXC、Trans2 QueryD、Tree Disconnect
What two are the prerequisites for enabling Flashback Database?（） (Choose two)A、The database must be in ARCHIVELOG modeB、The database must be in MOUNT EXCLUSIVE modeC、The database must be opened in RESTRICTED modeD、The database instance must be started in the NOMOUNT stateE、The database instance must have the keep buffer pool defined
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
What two are the prerequisites for enabling Flashback Database？（） A、 The database must be in ARCHIVELOG modeB、 The database must be in MOUNT EXCLUSIVE modeC、 The database must be opened in RESTRICTED modeD、 The database instance must be started in the NOMOUNT stateE、 The database instance must have the keep buffer pool defined
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 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 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
多选题What two are the prerequisites for enabling Flashback Database?（）AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT stateEThe database instance must have the keep buffer pool defined
多选题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
多选题What two are the prerequisites for enabling Flashback Database?（） (Choose two)AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT stateEThe database instance must have the keep buffer pool defined
多选题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 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
多选题For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)AviewsBfixed tablesCheap tablesDexternal tablesEtemporary tablesFindex-organized tables (IOT)