Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

• A.The number of table rows is considered when evaluating the cost of accessing a table using an index.
• B.Index balanced B*Tree height is considered when evaluating the cost of using an index.
• C.The Statistics Advisor can help recommend the best way to gather statistics.
• D.Statistics collected using DBMS_STATS always yield the best optimizer result.
• E.The Statistics Advisor generates actions for all recommendations.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about RMAN duplexed backup sets?

• A.They can be written only to disk.
• B.They can be written to media.
• C.They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
• D.They can be created only by using the COPIES option of a BACKUP command.
• E.They must be written to media.

Comment: *

Name: *

Email: *

Verification: *

A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

• A.after losing an archived log from before the most recent backup
• B.when any archived log from, before, or after the most recent backup is corrupt.
• C.after losing all copies of the control file
• D.after losing the SYSTEM tablespace
• E.after losing an archived log from after the most recent backup

Comment: *

Name: *

Email: *

Verification: *

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)

• A.Increase the level of RMAN multiplexing.
• B.Enable asynchronous disk I/O.
• C.Increase the size of the database buffer cache.
• D.Increase the size of tape I/O buffers.
• E.Disable FORCE LOGGING for the database.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

• A.Data files can be converted on the source system.
• B.The password file is automatically converted by RMAN.
• C.Data files can be converted on the destination system.
• D.Databases can be transported between systems with different endian formats.
• E.By default, the transported database will use Oracle Managed Files (OMF)
• F.A new DBID is automatically created for the transported database.

Comment: *

Name: *

Email: *

Verification: *