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 colum