Question

. Under which of these circumstances might Flashback Database be of use?

A. To recover a dropped table

B. To recover a dropped schema

C. To recover a damaged datafile

D. To reverse a bad transaction

E. All of the above

Answer 1

Answer: B) To recovered a dropped schema

Step-by-step explanation:

By using the flashback database charactertics we can recovered a dropped user by using its schema. In the flashback database, the user executed the test which should be dropped and recovered.

Flashback database method are used to recover dropped user only when the database are in archive mode and flashback is enable for the database.

After schema dropped, it is mandatory to keep all the objects that are created during this process.