Oracle Database Administration II — Question 156

Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)? (Choose two.)

Answer options

• A. A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
• B. A PDB Lockdown profile can be created in an application root.
• C. A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.
• D. A PDB Lockdown profile can be created in CDB$ROOT.
• E. A PDB Lockdown profile can be created in a regular PDB.

Correct answer: B, D

Explanation

Option B is correct because PDB Lockdown profiles can indeed be created in an application root. Option D is also accurate as it states that a PDB Lockdown profile can be created in CDB$ROOT. Options A and C contradict each other regarding automatic modifications of Lockdown profiles, and E is incorrect as it does not specifically address the creation context of PDB Lockdown profiles.