exam questions

Exam 1z0-053 All Questions

View all questions & answers for the 1z0-053 exam

Exam 1z0-053 topic 11 question 30 discussion

Actual exam question from Oracle's 1z0-053
Question #: 30
Topic #: 11
[All 1z0-053 Questions]

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?

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...