OCP Database Architecture & Administration 3 — Questions and Answers
Question 1: Which Oracle feature allows multiple databases to share a single set of Oracle binaries installed on the server?
- Oracle RAC
- Oracle Multitenant (Correct answer)
- Optimal Flexible Architecture (OFA)
- Oracle ASM
Correct answer: Oracle Multitenant
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?
- They are automatically committed on restart
- They are rolled back during instance recovery using redo logs (Correct answer)
- They are stored in a special recovery area until manually resolved
- They are permanently lost and cannot be recovered
Correct 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.
Question 3: Which Oracle tablespace type stores temporary segments used for sort operations and global temporary tables?
- SYSTEM tablespace
- UNDO tablespace
- Temporary tablespace (Correct answer)
- Default permanent tablespace
Correct answer: Temporary tablespace
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?
- CDB$ROOT data dictionary (Correct answer)
- PDB$SEED data dictionary
- Each PDB's own dictionary only
- A shared external LDAP directory
Correct 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.
Question 5: Which Oracle parameter determines the maximum number of simultaneous user sessions that can connect to the database?
- PROCESSES
- SESSIONS (Correct answer)
- OPEN_CURSORS
- TRANSACTIONS
Correct answer: SESSIONS
The SESSIONS parameter sets the maximum number of sessions that can be simultaneously connected to the Oracle instance.
Question 6: What is the primary purpose of Oracle Undo tablespace?
- Store archived redo log files
- Provide read consistency and support transaction rollback (Correct answer)
- Cache frequently accessed index blocks
- Store temporary sort segments
Correct 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.
Question 7: Which tool is used to create and modify Oracle database initialization parameter files (SPFILE)?
- RMAN
- ALTER SYSTEM SET command (Correct answer)
- DBCA (Database Configuration Assistant)
- SQL*Loader
Correct 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.
OCP Database Architecture & Administration 3
Which Oracle feature allows multiple databases to share a single set of Oracle binaries installed on the server?