What would be the outcome of the precedent statement?

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:
SQL> SELECT object_name, original_name, droptime, FROM recyclebin;
OBJECT_NAME ORIGINAL_NAME DROPTIME
————————————– ———————- ———————
BIN$/m0DrBV9RFGOAA53dC+FPW==$0 SALES_EMP 2007-12-07:11:08:55
BIN$2DeIssLeQTqgH/n80Rm2JQ==$0 SALES_EMP 2007-12-07:11:11:38
BIN$UuqroNodQy6ouDtaA+XOVw==$0 SALES_EMP 2007-12-07:11:08:18
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?

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:
SQL> SELECT object_name, original_name, droptime, FROM recyclebin;
OBJECT_NAME ORIGINAL_NAME DROPTIME
————————————– ———————- ———————
BIN$/m0DrBV9RFGOAA53dC+FPW==$0 SALES_EMP 2007-12-07:11:08:55
BIN$2DeIssLeQTqgH/n80Rm2JQ==$0 SALES_EMP 2007-12-07:11:11:38
BIN$UuqroNodQy6ouDtaA+XOVw==$0 SALES_EMP 2007-12-07:11:08:18
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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


peocc

peocc

043 has a similar question but with answer D. I think D is not correct.