Tables in recycle bin can be recovered back into database by using

Options
- Flashback
- Flashback Drop
- Revoke
- Revoke_Table

CORRECT ANSWER : Flashback Drop

Discussion Board
Flashback Drop

Tables in recycle bin can be recovered back into database by using Flashback Drop. When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is called Flashback Drop, and the Flashback Table statement is used to restore the table.

Prajakta Pandit 02-10-2017 06:16 AM

correct answer is FLASHBACK ... TO BEFORE DROP;

FLASHBACK TABLE table_name TO BEFORE DROP; At this point flashback is correct answer too.

Maksim 01-3-2014 05:34 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲