---

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）
A:It retrieves the latest version of the table from the recycle bin
B:It retrieves the oldest version of the table from the recycle bin
C:It retrieves the version of the table for which undo information is available
D:It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

---

出自：Oracle认证

显示答案