You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A.Set DB_FLASH_CACHE_ZISE = 64G.
• B.Set DB_FLASH_CACHE_ZISE = 64G, 64G
• C.Set DB_FLASH_CACHE_ZISE = 128G.
• D.DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)?

• A.Its results are stored in AWR.
• B.It provides recommendations only for poorly performing SQL statements.
• C.It calls SQL advisors automatically if required.
• D.It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
• E.It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

Comment: *

Name: *

Email: *

Verification: *

Your database supports an online transaction processing (OLTP) application. The application is
undergoing some major schema changes, such as addition of new indexes and materialized views. You
want to check the impact of these changes on workload performance.
What should you use to achieve this?

• A.Database replay
• B.SQL Tuning Advisor
• C.SQL Access Advisor
• D.SQL Performance Analyzer
• E.Automatic Workload Repository compare reports

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.) (Choose three.)

• A.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• B.To enable flashback database, the CDB must be mounted.
• C.Individual PDBs can be flashed back without flashing back the entire CDB.
• D.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
• E.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Oracle Restart? (Choose three.)

• A.While starting any components, it automatically attempts to start all dependencies first and in proper order.
• B.It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• C.It runs periodic check operations to monitor the health of Oracle components.
• D.It can be configured to automatically attempt to restart various components after a hardware or software failure.
• E.It can be used to only start Oracle components.

Comment: *

Name: *

Email: *

Verification: *