Which statement represents the Segment Advisor’s feature?

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 […]

Read More

Which four statements represent features of the segment shrink operation?

Which four statements represent features of the segment shrink operation? (Choose four.) A.The shrink operation decreases the size of the tablespace. B.The shrink operation reclaims wasted space in a tablespace. C.In a shrink operation, data is compacted to the end of the table. D.In a shrink operation, data is compacted to the front of the […]

Read More

Which four options represent the features of Oracle Undo Advisor?

Which four options represent the features of Oracle Undo Advisor? (Choose four.) A.Oracle Undo Advisor advises you on when to implement automatic undo retention. B.Oracle Undo Advisor recommends when you must create another UNDO tablespace. C.Oracle Undo Advisor provides the best retention possible for the given undo tablespace. D.Oracle Undo Advisor provides guidance on how […]

Read More

Which three statements about media recovery are correct?

Which three statements about media recovery are correct? (Choose three.) A.Media recovery is used when you accidentally drop a tablespace. B.Media recovery brings your database to a transactionally consistent state when it is opened. C.Point-in-time media recovery returns your database to its state at a specified time in the past. D.Media recovery requires an SPFILE, […]

Read More

What happens when you try to start an instance and connect to the database?

A control file has been accidentally deleted. What happens when you try to start an instance and connect to the database? A.The database opens using another control file automatically. B.An error message is displayed and the database is not mounted. C.The database mounts but an error message appears stating that the database cannot be opened. […]

Read More