Oracle Business Process Management Suite 12c Essentials
Oracle Hyperion Financial Management 11 Essentials
Oracle SOA Suite 12c Essentials
Oracle WebLogic Server 12c Essentials
Java SE 8 Programmer II
Oracle Business Intelligence Foundation Suite 11g Essentials
Siebel 8 Consultant
Oracle WebLogic Server 12c: Administration I
Oracle VM 3 for x86 Essentials
Oracle Database 12c Essentials
Which two statements are true about the PMON background process?
It registers database services with all local and remote listeners known to the database instance.
It records checkpoint information in the control file.
It frees resources held by abnormally terminated processes.
It rolls back transactions when a process fails.
It frees unused temporary segments.
A.False. LREG handles registration in 23ai, not PMON.
B.False. CKPT (Checkpoint) process updates the control file.
C.True. PMON cleans up after failed processes (e.g., releases locks).
D.True. PMON rolls back uncommitted transactions of failed processes.
E.False. SMON (System Monitor) manages temporary segment cleanup.
Which of the following is true about the status of a PDB that has been unplugged from a CDB?
The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.
The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.
A.True. After ALTER PLUGGABLE DATABASE ... UNPLUG, CDB_PDBS.STATUS shows UNPLUGGED.
B.False. UNAVAILABLE isn’t a valid status here.
C.False. REMOVED isn’t used; UNPLUGGED persists until dropped.
D.False. DISABLED isn’t a PDB state in this context.
At which two container database levels can COMMON Unified Audit Policies be used?
COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.
At the CDB level.
At the Application Root level of an Application Container.
At any level by using the COMMON option in the policy.
At the PDB level if the policy is created by a COMMON user.
A.False. Not limited to CDB; PDBs can use common policies.
B.True. Common policies apply at CDB level.
C.False. Application Root uses app-specific policies.
D.False. “COMMON option” isn’t a feature; policies are common by creation context.
E.True. A common user can create policies for PDBs.