QUESTION 194-It retrieves the most recently dropped version of the table.
You plan to use the Flashback Drop feature to recover the SALES_EMP table that was dropped in error.
No other table with the sname name exists in the SH schema, which owns the table.
You query the RECYCLEBIN and file multiple entries for the SALES_EMP table:
SQL> SELECT object_name, original_name, droptime FROM recyclebin;
OBJECT_NAME ORIGINAL_NAME DROPTIME
------------------------------------------------------------------ ------------------------------------- --------------------------------------------
BIN$/msldfsoidhjfknsjdsdkjflksdjkfjsdksfl==$0 SALES_EMP 2012-12-07:12:28:55
BIN$/SDFLKSJLDFsdkjfjsdfjkaldofhohgo==$0 SALES_EMP 2013-12-07:10:11:38
BIN$/kkljsdkfjisdjnlksjflkassdfkjklkljfljaslk==$0 SALES_EMP 2012-12-07:09:08:18
You then issue this statement to recover the table:
SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;
What would be the result?
A. It retrieves the most recently dropped version of teh table from the recyclebin for witch undo is still available.
B. It retrieves the most recently dropped version of the table.
C. It retrieves the least recently dropped version of the table.
D. It retrieves the least recently droppe version of the table from the recyclebin for which undo is still available.
E. It returns an error because the table name in the OBJECT_NAME columns not specified.
Correct Answer: B