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
上一篇:Improving Question Answering with External Knowledge


下一篇:autojs通过SQL获取答案