Oracle Database Administration II — Question 88

Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

Answer options

• A. A table's constraints must be disabled before issuing the flashback.
• B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
• C. A table's indexes must be set to unusable before issuing the flashback.
• D. Row Movement must be enabled on the table being flashed back.
• E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

Correct answer: B, D

Explanation

The correct answers are B and D because the user must have the appropriate privileges to perform a flashback operation, as stated in option B, and Row Movement must be enabled for the flashback to work, as indicated in option D. Options A and C are incorrect as they are not required prerequisites, and option E is irrelevant since the privileges need to be granted to the user performing the action, not just the table owner.