Category «1Z0-041»

Exam 1Z0-041, Oracle Database 10g: 2 Day DBA Assessment Exam

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 …

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, …

If you want the Oracle server to manage the size of the SGA dynamically on its own, then which option would be

You manually configured the System Global Area (SGA). If you want the Oracle server to manage the size of the SGA dynamically on its own, then which option would be the solution? A.You enable Automatic Shared Memory Management. B.You disable Automatic Shared Memory Management. C.You use the memory advisor to determine and provide new settings …