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

Exam 1z0-063 All Questions

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

Exam 1z0-063 topic 1 question 190 discussion

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

Which three statements are true about the database instance startup after an instance failure?

  • A. The RECO process recovers the uncommitted transactions at the next instance startup.
  • B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
  • C. Uncommitted changes are rolled back to ensure transactional consistency.
  • D. The SMON process coordinates the database recovery.
  • E. Media recovery is required to complete the database recovery.
  • F. Changes committed before the failure, which were not written to the data files, are re-applied.
Show Suggested Answer Hide Answer
Suggested Answer: ACD 🗳️
A: Occasionally a database closes abnormally with one or more distributed transactions in doubt (neither committed nor rolled back). When you reopen the database and recovery is complete, the RECO background process automatically, immediately, and consistently resolves any in-doubt distributed transactions.
C: Crash and instance recovery involve two distinct operations: rolling forward the current, online datafiles by applying both committed and uncommitted transactions contained in online redo records, and then rolling back changes made in uncommitted transactions to their original state.
D: The SMON background process performs instance recovery, applying online redo automatically. No user intervention is required.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm https://docs.oracle.com/database/121/CNCPT/startup.htm
by alipilot2006 at April 25, 2019, 8:02 a.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
hilaire
3 years, 3 months ago
CDF correct
upvoted 1 times
...
sergezaza83
4 years ago
ACD is correct
upvoted 1 times
...
Sugar
4 years, 5 months ago
I agree C D F
upvoted 2 times
...
sherifelia
4 years, 10 months ago
answer CDF
upvoted 1 times
...
Sherry
5 years, 3 months ago
The correct answer is CDF. For A. RECO (Oracle RECOverer Process) is an Oracle background process created when you start an instance with DISTRIBUTED_TRANSACTIONS= in the initialization parameter file. The RECO process will try to resolve in-doubt transactions across Oracle distributed databases.
upvoted 1 times
...
alipilot2006
5 years, 7 months ago
The answer is "CDF"
upvoted 3 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