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
第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 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? ()
第3题:
A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined
第4题:
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
第5题:
Which two prerequisites are needed for performing workload capture and replay?()
第6题:
What two are the prerequisites for enabling Flashback Database?() (Choose two)
第7题:
What two are the prerequisites for enabling Flashback Database?()
第8题:
A. Flash recovery area must be defined
B. 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).
第9题:
What are the prerequisites for performing flashback transactions? ()(Choose all that apply)
第10题:
What are the prerequisites for enabling Flashback Database? ()