1.Which two are prerequisites for creating a backup-based duplicate database?

• A.creating a password file for an auxiliary instance
• B.creating an SPFILE for the target database
• C.connecting to an auxiliary instance
• D.connecting to the target database and a recovery catalog to execute the duplicate command
• E.matching the database identifier (DBID) of the source database and the duplicate database

Comment: *

Name: *

Email: *

Verification: *

Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?

• A.REPORT OBSOLETE
• B.LIST EXPIRED
• C.LIST ARCHIVELOG
• D.LIST ARCHIVELOG ALL
• E.RESYNC CATALOG
• F.CROSSCHECK BACKUP OF ARCHIVELOG ALL

Comment: *

Name: *

Email: *

Verification: *

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

• A.general operating system health
• B.SQL statements
• C.database writer performance
• D.database instance memory management and sizes
• E.log writer performance

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2 only
• B.PDB$SEED, PDB1, and PDB2 only
• C.CDB1, PDB$SEED, and PDB1 only
• D.CDB1 and PDB$SEED only
• E.CDB1, PDB$SEED, PDB1, and PDB2

Comment: *

Name: *

Email: *

Verification: *

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