Database Architecture & Administration Flashcards

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

Answer: Oracle Multitenant

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

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

Answer: They are rolled back during instance recovery using redo logs

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

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

Answer: Temporary tablespace

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

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

Answer: CDB$ROOT data dictionary

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

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

Answer: SESSIONS

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

What is the primary purpose of Oracle Undo tablespace?

Answer: Provide read consistency and support transaction rollback

The undo tablespace stores before-images of changed data to support read consistency, transaction rollback, and Flashback operations.

Which tool is used to create and modify Oracle database initialization parameter files (SPFILE)?

Answer: ALTER SYSTEM SET command

The ALTER SYSTEM SET command modifies SPFILE parameters dynamically, with changes persisting across restarts when SCOPE=SPFILE or BOTH is specified.