nerdexam
Oracle

1Z0-067 · Question #216

1Z0-067 Question #216: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #216. The question stem and answer options stay visible for context.

Question

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo retention?

Options

  • AUndo becomes expired obsolete after 1000 seconds.
  • BInactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the
  • CInactive undo is retained for at least 1000 seconds if free undo space is available.
  • DUndo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM

Unlock 1Z0-067 to see the answer

You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-067 Practice