Oracle Exam 1Z0-060 Topic 9 Question 41 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 41
Topic #: 9

You plan to use the Flashback Drop feature to recover the sales_emp table that was dropped in error. No other table with the same name exists in the sh schema, which owns the table. You query the recyclebin and find multiple entries for the salesemp table:

SQL FLASHBACK TABLE sale_emp To BEFORE DROP:

What would be the result?

AIt returns an error because the table name in the object_name column is not specified.

BIt retrieves the least recently dropped version of the table from the recycle bin for which undo is still available.

CIt retrieves the most recently dropped version of the table.

DIt retrieves the most recently dropped version of the table from the recycle bin for which undo Is still available.

EIt retrieves the least recently dropped version of the table.

Show Suggested Answer

Suggested Answer: E

by Elvera at May 26, 2022, 08:03 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!