Choose two. Which two are true about server-generated alerts?

• A.Stateless alerts are automatically cleared after one day.
• B.Stateless alerts can be purged manually from the alert history.
• C.Stateless alerts can be cleared manually.
• D.Stateful alerts are purged automatically from the alert history after one day.
• E.Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

• A.Data file 24 can be recovered while PDB2 is opened.
• B.Data file 24 cannot be recovered while the CDB is opened.
• C.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
• D.Data file 24 must be recovered while PDB2 is closed.
• E.Data file 24 must be recovered while the CDB is opened.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A.Reduced physical I/O
• B.Reduced logical I/O
• C.Reduced virtual memory utilization
• D.Improved Serial Execution performance
• E.Reduced CPU utilization

Comment: *

Name: *

Email: *

Verification: *