OCP CBT Question 493

Please solve the following question.

You are administering `CDB01` and notice that a parameter, `OPTIMIZER_MODE`, is set at the CDB root level. Which statement is true regarding how `OPTIMIZER_MODE` behaves for a newly created PDB within `CDB01`?

The CDB is running Oracle Database 19c.

The OPTIMIZER_MODE parameter is inherited by the PDB from the CDB root and can be changed within the PDB.

The OPTIMIZER_MODE parameter is inherited by the PDB from the CDB root, but it is a read-only parameter at the PDB level.

The PDB will ignore the OPTIMIZER_MODE setting from the CDB root and use its own default value unless explicitly set at the PDB level.

OPTIMIZER_MODE is a PDB-specific parameter and must always be set explicitly for each PDB; it is not inherited.