ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 63 discussion

Actual exam question from Oracle's 1z0-062
Question #: 63
Topic #: 1
[All 1z0-062 Questions]

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

  • A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.
  • B. Recover the table using traditional Tablespace Point In Time Recovery.
  • C. Recover the table using Automated Tablespace Point In Time Recovery.
  • D. Recovery the table using Database Point In Time Recovery.
  • E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
RMAN tablespace point-in-time recovery (TSPITR).
Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.
Fully Automated (the default)
In this mode, RMAN manages the entire TSPITR process including the auxiliary instance. You specify the tablespaces of the recovery set, an auxiliary destination, the target time, and you allow RMAN to manage all other aspects of TSPITR.
The default mode is recommended unless you specifically need more control over the location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel settings and parameters or some other aspect of your auxiliary instance.
by Phoenix22 at March 26, 2020, 6:54 p.m.

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
Submit Cancel
TuxBingo
4 years, 9 months ago
Agree with the answer C Lik Oracle documentation:https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV89790
upvoted 2 times
...
Phoenix22
5 years, 1 month ago
Why is not E?
upvoted 1 times
TuxBingo
4 years, 9 months ago
Hi Phoenix22 When you perform a drop user or drop user cascade, the recycle bin is purge by default. Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9008.htm "When you drop a user, Oracle Database also purges all of that user's schema objects from the recycle bin." Regards.
upvoted 5 times
...
Blade69
3 years, 1 month ago
This is a version 11g database if it was version 12 then E is the correct answer.
upvoted 1 times
...
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago