OCP Database Architecture & Administration 3

Question 1

Which Oracle feature allows multiple databases to share a single set of Oracle binaries installed on the server?

Accepted Answer

Oracle Multitenant

Answer

Oracle Multitenant allows multiple pluggable databases (PDBs) to share one set of Oracle binaries within a container database (CDB).

Question 2

What happens to uncommitted transactions when an Oracle instance crashes unexpectedly?

Accepted Answer

They are rolled back during instance recovery using redo logs

Answer

During instance recovery, SMON applies redo to roll forward committed changes and rolls back uncommitted transactions using undo data.

Question 3

Which Oracle tablespace type stores temporary segments used for sort operations and global temporary tables?

Accepted Answer

Temporary tablespace

Answer

Temporary tablespaces store temporary segments used for sort operations, hash joins, and global temporary table data.

Question 4

In an Oracle CDB/PDB architecture, which dictionary stores the metadata for the entire container database including all PDBs?

Accepted Answer

CDB$ROOT data dictionary

Answer

CDB$ROOT (the root container) holds the CDB-wide data dictionary, while each PDB has its own local dictionary for its objects.

Question 5

Which Oracle parameter determines the maximum number of simultaneous user sessions that can connect to the database?

Accepted Answer

SESSIONS

Answer

The SESSIONS parameter sets the maximum number of sessions that can be simultaneously connected to the Oracle instance.

(OCP) Oracle Certified Professional Practice Test