Next Question

A long running query to a database fails to execute because the undo records for this query have been overwritten. Which two of these options provide a solution to this problem? (Choose two.)
Which statement represents the Segment Advisor’s feature?

A.
The Segment Advisor provides advice on whether a segment has space available for reclamation based on the level of space fragmentation within the segment.

B.
The Segment Advisor provides advice on whether an extent has space available for reclamation based on the level of space fragmentation within the extent.

C.
The Segment Advisor provides advice on whether the database has space available for reclamation based on the level of space fragmentation within the tablespaces.

D.
The Segment Advisor provides advice on whether a tablespace has space available for reclamation based on the level of space fragmentation within the tablespace.

Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *