Flashback Database must be enabled.
Undo retention guarantee for the database must be configured.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Supplemental logging must be enabled.
Recycle bin must be enabled for the database.
Block change tracking must be enabled tor the database.
第1题:
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.
第2题:
What two are the prerequisites for enabling Flashback Database?() (Choose two)
第3题:
What two are the prerequisites for enabling Flashback Database?()
第4题:
What are the prerequisites for performing flashback transactions? ()(Choose all that apply)
第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?()
第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.)
第7题:
ALTER DATABASE FLASHBACK ON;
GRANT SELECT any transaction TO scott;
GRANT EXECUTE ON dbms_flashback TO scott;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER TABLESPACE undots1 RETENTION GUARANTEE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第8题:
The database must be in ARCHIVELOG mode
The database must be in MOUNT EXCLUSIVE mode
The database must be opened in RESTRICTED mode
The database instance must be started in the NOMOUNT state
The database instance must have the keep buffer pool defined
第9题:
Undo retention guarantee for the database must be configured.
Supplemental log must be enabled for the primary key.
Supplemental log must be enabled.
Execute permission on the DBMS_FLASHBACK package must be granted to the user.
第10题:
The database must be in ARCHIVELOG mode
The database must be in MOUNT EXCLUSIVE mode
The database must be opened in RESTRICTED mode
The database instance must be started in the NOMOUNT state
The database instance must have the keep buffer pool defined
第11题:
Database must be running in archivelog mode.
Automatic undo management must be enabled.
Undo retention guarantee must be enabled.
The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
第12题:
ALTER DATABASE FLASHBACK ON
GRANT SELECT any transaction TO scott
GRANT EXECUTE ON dbms_flashback TO scott
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
ALTER TABLESPACE undots1 RETENTION GUARANTEE
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
第13题:
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?()
第14题:
Which are the prerequisites for performing flashback transactions on your database?()
第15题:
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)
第16题:
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)
第17题:
Which two are prerequisites for performing a flashback transaction?()
第18题:
Which two are the prerequisites to enable Flashback Data Archive?()
第19题:
ALTER DATABASE FLASHBACK ON;
GRANT SELECT any transaction TO scott;
GRANT EXECUTE ON dbms_flashback TO scott;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER TABLESPACE undots1 RETENTION GUARANTEE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第20题:
Flash recovery area must be defined
Undo retention guarantee must be enabled.
Database must be running in archivelog mode.
Automatic undo management must be enabled.
The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
第21题:
Flashback Database must be enabled.
Undo retention guarantee for the database must be configured.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Supplemental logging must be enabled.
Recycle bin must be enabled for the database.
Block change tracking must be enabled tor the database.
第22题:
Database must be running in archivelog mode.
Automatic undo management must be enabled.
Undo retention guarantee must be enabled.
The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
第23题:
Enable supplemental logging for the database.
Specify undo retention guarantee for the database.
Create a Flashback Data Archive in the tablespace where the tables are stored.
Create a Flashback Data Archive in any suitable tablespace.
Enable Flashback Data Archiving for the tables that require tracking
第24题:
Supplemental log must be enabled
Supplemental log must be enabled for the primary key
Undo retention guarantee for the database must be configured
”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user