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.
第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题:
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()
第3题:
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
第4题:
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)
第5题:
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)
第6题:
Which two are prerequisites for performing a flashback transaction?()
第7题:
Which two are the prerequisites to enable Flashback Data Archive?()
第8题:
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;
第9题:
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).
第10题:
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).
第11题:
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
第12题:
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
第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题:
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?()
第16题:
What are the prerequisites for performing flashback transactions? ()(Choose all that apply)
第17题:
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?()
第18题:
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.)
第19题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第20题:
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;
第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题:
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