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: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• C.It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• D.It is always possible for RMAN to connect to a pluggable database as a target.
• E.A Virtual Private Catalog used to register a container database can be created in a non-container database.
• F.A Virtual Private Catalog used to registera container database can be created in a pluggable database.

Comment: *

Name: *

Email: *

Verification: *

On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August.
Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?

• A.all backups prior to 24th of August
• B.all backups prior to 10th of August
• C.all backups prior to 17th of August
• D.all backups prior to 20th of August
• E.all backups prior to 22nd of August

Comment: *

Name: *

Email: *

Verification: *

Which two are true about flashback features in Oracle Database 19c and later releases?

• A.Flashback logs are monitored for being older than the retention period defined in db_flashback_retention_target and can be deleted by an administrator written event trigger.
• B.Flashback logs are automatically purged whenever the value
  Of DB_FLASHBACK_RETENTION_TARGET is changed.
• C.Flashback logs are monitored and proactively deleted when beyond the retention period defined in db_flashback_retention_target before there is space pressure.
• D.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_flashback_retention_TARGET only after there is space pressure
• E.Flashback logs are automatically purged when db_flashback_retention_target is set lower than the time they have already been retained.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle database tuning methodology?

• A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B.Tuning activities should stop once agreed service levels for performance have been met.
• C.Tuning activities should stop once the user is satisfied with performance.
• D.The alert log should be used to find the database and instance areas most in need of tuning.
• E.SQL statements should always be tuned before tuning any file systems.
• F.The database instance memory should always be tuned before tuning any file systems.

Comment: *

Name: *

Email: *

Verification: *