nerdexam
Oracle

1Z0-052 · Question #159

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo

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

Managing Undo Data

Question

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

Options

  • AThe retention period to support flashback
  • BThe expected length of the longest-running query
  • CThe number of undo tablespaces in the database
  • DThe size of the Flash Recovery Area for the database instance

Unlock 1Z0-052 to see the answer

You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.

Topics

#Undo Advisor#undo tablespace sizing#flashback retention#longest-running query
Full 1Z0-052 Practice