On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct?() 
A:You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
B:You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
C:You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
D:You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of  the recycle bin are purged every 12 hours by default.
出自:Oracle认证