Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

• A.All metrics are instance related.
• B.Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
• C.A space usage management alert is automatically cleared after the underlying problem is resolved.
• D.They are generated by SMON when a tablespace is 97% full.
• E.Metrics are statistical counts for a specific unit.
• F.STATISTICS_LEVELmust be set to ALLto generate alerts.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

• A.A failure can be closed only when it has been repaired.
• B.The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.
• C.Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.
• D.Data Recovery Advisor can be used if a database is closed.
• E.Data Recovery Advisor can proactively check for failures.

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.CDB1, PDB$SEED, PDB1, and PDB2
• C.CDB1, PDB$SEED, and PDB1 only
• D.PDB$SEED, PDB1, and PDB2 only
• E.CDB1 and PDB$SEED only

Comment: *

Name: *

Email: *

Verification: *

Which three are true about opatchauto?

• A.Patchsets are applied via opatchauto.
• B.It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
• C.It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• D.It Is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
• E.It applies patches in nonrolling mode by default.
• F.It must be invoked by a user with root user privileges.
• G.Users must always input patch plans to opatchauto.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

• A.C##_APP_USER1 can be created in CDB1.
• B.APP1_USER1can be created in CDB1.
• C.APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
• D.APP1_USER1can be created in PDB1.
• E.P1_USER1can be created in CDB1.
• F.C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

Comment: *

Name: *

Email: *

Verification: *