QUESTION 194-It retrieves the most recently dropped version of the table.

本文主要是介绍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

这篇关于QUESTION 194-It retrieves the most recently dropped version of the table.的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！