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> SELECT object_name, original_name, droptime FROM recyclebin; What would be the outcome of the precedent statement?

Question

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> SELECT object_name, original_name, droptime FROM recyclebin; What would be the outcome of the precedent statement?

Accepted Answer

A. It retrieves the latest version of the table from the recycle bin

Answer

B. It retrieves the oldest version of the table from the recycle bin

Answer

C. It retrieves the version of the table for which undo information is available

Answer

D. It returns an error because the table name is not specified as per the names in the

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…

Question

Exhibit

Options

How the community answered

Community Discussion