Why Practice Questions Matter
If you’re preparing for the Oracle Database Administration I (1Z0-082) exam—often still called the “Oracle 19c OCA” by many candidates—working with sample questions is one of the most effective ways to check your readiness. The exam covers a wide range of DBA essentials, from instance architecture to backup and recovery. Practicing with realistic questions helps you identify weak spots before exam day.
Sample Questions by Exam Domain
Section 1: Oracle Database Architecture
Q1. Which two background processes write redo log buffer entries to disk?
a) LGWR
b) CKPT
c) SMON
d) DBWR
Answer: a) LGWR, b) CKPT
Explanation: LGWR writes redo from buffer to log files; CKPT updates control files and datafile headers during checkpoints.
Q2. Where is the Oracle password file located by default in a Linux installation?
a) $ORACLE_HOME/dbs
b) $ORACLE_HOME/network/admin
c) $ORACLE_BASE/admin
d) $ORACLE_HOME/security
Answer: a) $ORACLE_HOME/dbs
Explanation: The password file orapw<SID> resides under $ORACLE_HOME/dbs on Linux/UNIX.
Q3. Which memory structure is exclusive to a dedicated server connection?
a) SGA
b) PGA
c) Shared Pool
d) Buffer Cache
Answer: b) PGA
Explanation: The Program Global Area is private to a server process.
Section 2: User and Security Management
Q4. Which system privilege allows a user to connect to the database?
a) CREATE SESSION
b) CONNECT
c) GRANT SESSION
d) ALTER SESSION
Answer: a) CREATE SESSION
Explanation: This privilege is required to log in.
Q5. What is the effect of granting the WITH ADMIN OPTION clause?
a) User can revoke the privilege from others.
b) User can grant the privilege to others.
c) User can change system parameters.
d) User can drop other users’ tables.
Answer: b) User can grant the privilege to others.
Explanation: WITH ADMIN OPTION allows propagation of privileges.
Q6. Which account is locked by default in Oracle Database 19c?
a) SYS
b) SYSTEM
c) HR
d) DBSNMP
Answer: c) HR
Explanation: Demonstration schemas like HR are locked by default.
Section 3: Storage and Tablespaces
Q7. Which clause ensures a tablespace can automatically add space when full?
a) AUTOEXTEND ON
b) AUTOEXPAND
c) AUTOEXTEND FILE
d) RESIZE AUTO
Answer: a) AUTOEXTEND ON
Explanation: Enables automatic file growth.
Q8. What is the smallest unit of space allocation in Oracle?
a) Datafile
b) Extent
c) Block
d) Segment
Answer: c) Block
Explanation: Oracle allocates space in blocks.
Q9. Which segment stores undo information for transactions?
a) Temporary segment
b) Undo segment
c) Data segment
d) Index segment
Answer: b) Undo segment
Explanation: Undo records are stored in undo segments.
Section 4: Backup & Recovery (RMAN)
Q10. Which command lists backups in RMAN?
a) LIST BACKUP
b) SHOW BACKUP
c) DISPLAY BACKUP
d) REPORT BACKUP
Answer: a) LIST BACKUP
Explanation: Shows backups catalogued in RMAN repository.
Q11. Which RMAN feature allows block-level recovery of corrupted blocks?
a) Block Change Tracking
b) Block Media Recovery
c) Data Guard
d) Flashback Database
Answer: b) Block Media Recovery
Explanation: Repairs only damaged blocks without full restore.
Q12. Which RMAN backup type copies only blocks changed since last backup?
a) Full
b) Incremental
c) Cumulative
d) Consistent
Answer: b) Incremental
Explanation: Incremental backups minimize size and time.
Section 5: Multitenant Architecture (CDB/PDB)
Q13. Which users exist across all pluggable databases?
a) Local users
b) Common users
c) Schema owners
d) Proxy users
Answer: b) Common users
Explanation: Common users are created in CDB$ROOT and available in all PDBs.
Q14. Which container must you connect to in order to create a new PDB?
a) Seed PDB
b) Application Root
c) CDB$ROOT
d) Any PDB
Answer: c) CDB$ROOT
Explanation: PDBs are created from CDB$ROOT.
Q15. Which view shows all containers in a multitenant environment?
a) DBA_CONTAINERS
b) CDB_PDBS
c) DBA_PDBS
d) V$CONTAINERS
Answer: b) CDB_PDBS
Explanation: Lists PDB information for a CDB.
Section 6: Database Maintenance
Q16. Which tool generates the Automatic Workload Repository (AWR) report?
a) ADDM
b) STATSPACK
c) DBMS_WORKLOAD_REPOSITORY
d) Enterprise Manager only
Answer: c) DBMS_WORKLOAD_REPOSITORY
Explanation: AWR snapshots and reports are generated via this package.
Q17. Which advisor identifies SQL statements causing high resource usage?
a) SQL Tuning Advisor
b) Segment Advisor
c) Undo Advisor
d) Memory Advisor
Answer: a) SQL Tuning Advisor
Explanation: Provides tuning recommendations for SQL.
Q18. Which dictionary view lists invalid objects?
a) DBA_TABLES
b) DBA_ERRORS
c) DBA_OBJECTS
d) DBA_INVALID
Answer: c) DBA_OBJECTS
Explanation: Contains column STATUS showing invalid objects.
Section 7: Performance & Diagnostics
Q19. Which background process performs instance recovery?
a) DBWR
b) PMON
c) SMON
d) CKPT
Answer: c) SMON
Explanation: SMON handles instance and crash recovery.
Q20. Which dynamic view displays active user sessions?
a) V$SESSION
b) V$PROCESS
c) V$INSTANCE
d) DBA_USERS
Answer: a) V$SESSION
Explanation: Shows details of each current session.
Q21. Which wait event indicates contention for undo segments?
a) enq: TX – row lock contention
b) buffer busy waits
c) enq: US – contention
d) log file sync
Answer: c) enq: US – contention
Explanation: Related to undo segment space.
Section 8: Database Utilities
Q22. Which utility is used to move data between Oracle databases?
a) Data Pump
b) RMAN
c) SQL*Loader
d) GoldenGate
Answer: a) Data Pump
Explanation: expdp/impdp used for logical exports and imports.
Q23. Which SQL*Loader mode appends data to a table?
a) REPLACE
b) INSERT
c) TRUNCATE
d) APPEND
Answer: d) APPEND
Explanation: Adds rows without removing existing ones.
Q24. Which Oracle utility generates DDL scripts from the database?
a) Data Pump
b) DBNEWID
c) DBCA
d) DBMS_METADATA
Answer: d) DBMS_METADATA
Explanation: Extracts object definitions as DDL.
Q25. Which package allows scheduling jobs inside the database?
a) DBMS_LOCK
b) DBMS_SCHEDULER
c) DBMS_JOB only
d) DBMS_ALERT
Answer: b) DBMS_SCHEDULER
Explanation: Preferred method for scheduling tasks in modern Oracle versions.
Final Notes
- These 25 sample questions cover all major exam domains: architecture, security, storage, backup/recovery, multitenant, maintenance, performance, and utilities.
- They’re designed for practice, not memorization—use them to identify weak areas and revisit Oracle documentation or labs.
Comments 1