多选题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.
参考解析
解析：
暂无解析
相关考题：
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;
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).
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
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.
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;
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
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.
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).
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 are the prerequisites to enable Flashback Data Archive?（） (Choose two.)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).
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 ONB、 GRANT SELECT any transaction TO scottC、 GRANT EXECUTE ON dbms_flashback TO scottD、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATAE、 ALTER TABLESPACE undots1 RETENTION GUARANTEEF、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS
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.
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;
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）.
多选题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?（）AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
多选题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.)AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
多选题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 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 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.
多选题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?（） (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).
多选题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）.
多选题You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the database.CCreate a Flashback Data Archive in the tablespace where the tables are stored.DCreate a Flashback Data Archive in any suitable tablespace.EEnable Flashback Data Archiving for the tables that require tracking
多选题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？（）AALTER DATABASE FLASHBACK ONBGRANT SELECT any transaction TO scottCGRANT EXECUTE ON dbms_flashback TO scottDALTER DATABASE ADD SUPPLEMENTAL LOG DATAEALTER TABLESPACE undots1 RETENTION GUARANTEEFALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS
多选题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