200+ Free Oracle DBA Practice Questions

Pass your Oracle Database Administration Certified Professional exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

200+ Questions

100% Free

1 / 200

Question 1

Score: 0/0

You have completed a software-only install of Oracle Database in a new home. Which tool is typically used next to create the initial database?

Database Configuration Assistant

Oracle Net Manager

Recovery Manager

Listener Control utility

to track

2026 Statistics

Key Facts: Oracle DBA Exam

Exam Questions

Oracle University

60%

Passing Score

Oracle University

120 min

Exam Duration

Oracle University

$245

U.S. Exam Price

Oracle Technology exam subscription

25%

Largest Domain

Performance tuning

80-120 hrs

Recommended Prep

Typical lab-based study

As of March 11, 2026, Oracle's current DBA professional path uses a 65-question, 120-minute exam with a 60% passing score and a listed U.S. Oracle Technology exam price of $245. Oracle's April 11, 2025 Oracle University announcement published five weighted domains, led by performance tuning at 25%, with multitenant, backup and recovery, and current feature coverage each at 20%. This practice bank follows that current professional blueprint rather than older version-specific DBA-only tracks.

Sample Oracle DBA Practice Questions

Try these sample questions to test your Oracle DBA exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 200+ question experience with AI tutoring.

1You have completed a software-only install of Oracle Database in a new home. Which tool is typically used next to create the initial database?

A.Database Configuration Assistant

B.Oracle Net Manager

C.Recovery Manager

D.Listener Control utility

Explanation: A software-only installation puts the Oracle binaries on disk but does not create a database. DBCA is the standard utility for creating and configuring the initial database, including common starter settings for memory, storage, and multitenant layout.

2After applying a Release Update to the Oracle home with OPatch, why must a DBA run datapatch?

A.To relink the operating system kernel modules

B.To apply post-patch SQL changes to the data dictionary and database components

C.To rebuild the control files from scratch

D.To reset all administrative passwords

Explanation: OPatch updates the software binaries in the Oracle home, but many RUs also contain SQL changes for the database itself. Datapatch applies those dictionary and component updates so the database matches the patched home.

3What is the main purpose of AutoUpgrade analyze mode before upgrading a database?

A.It performs the upgrade but skips recompilation

B.It identifies readiness issues and fixups without changing the database version

C.It automatically converts every non-CDB into a PDB

D.It backs up the Fast Recovery Area to tape

Explanation: Analyze mode checks prerequisites, configuration issues, and recommended fixups before any upgrade work is done. This lets a DBA resolve problems early and lowers the risk of a failed upgrade window.

4Which Oracle Net file on a client most commonly stores local naming connect descriptors for service names?

A.listener.ora

B.sqlnet.ora

C.tnsnames.ora

D.spfile.ora

Explanation: The `tnsnames.ora` file is commonly used for local naming and maps service aliases to connect descriptors. By contrast, `listener.ora` configures the listener and `sqlnet.ora` controls broader network behavior such as naming methods and authentication settings.

5In Oracle Restart for a single-instance environment, which utility is used to manage database, listener, and ASM resources?

A.crsctl

B.srvctl

C.lsnrctl

D.asmcmd

Explanation: `srvctl` is the primary administration tool for managing Oracle resources such as databases, listeners, services, and ASM under Oracle Restart. `crsctl` is more focused on managing the Clusterware stack itself rather than day-to-day resource configuration.

6Why is out-of-place patching often preferred over in-place patching for an Oracle home?

A.It eliminates the need for backups

B.It leaves the previous home intact for easier fallback and a shorter risk window

C.It patches databases automatically without restart

D.It is the only method supported with Data Guard

Explanation: Out-of-place patching creates a new patched Oracle home while preserving the old one. That makes rollback and comparison simpler, and it reduces the operational risk if a post-patch validation issue appears.

7After a major version upgrade, which data dictionary view should a DBA query first to verify component status?

A.DBA_DATA_FILES

B.DBA_REGISTRY

C.DBA_USERS

D.V$ARCHIVED_LOG

Explanation: `DBA_REGISTRY` shows the installation status of Oracle components such as catalog packages and options after an upgrade. A DBA commonly checks it first, then follows up with invalid-object remediation such as `utlrp.sql` if needed.

8In a CDB environment, why should PDBs normally be opened before running datapatch?

A.Datapatch only works while the database is mounted

B.SQL patch changes are applied to open containers, so closed PDBs can be missed until reopened and patched

C.Listener registration requires all PDBs to be open first

D.The RMAN catalog must synchronize before datapatch can start

Explanation: Datapatch applies SQL changes to the containers that are open and available during its run. If some PDBs stay closed, they may not receive those updates until they are opened and datapatch is executed again.

9Which container stores Oracle-supplied metadata common to the entire CDB?

A.PDB$SEED

B.CDB$ROOT

C.SYSAUX

D.TEMP

Explanation: `CDB$ROOT` holds metadata and common objects shared across the multitenant container database. User application data generally belongs in PDBs, not in the root.

10What is the defining characteristic of a common user in a multitenant database?

A.It exists only inside one PDB

B.It is created in the root and can exist across containers

C.It owns only application root objects

D.It must remain locked in PDB$SEED

Explanation: A common user is created in the root and is known across the CDB according to multitenant rules. A local user, by comparison, belongs only to a single PDB and has no presence outside that container.

About the Oracle DBA Exam

Oracle's current professional DBA track focuses on administering modern Oracle Database environments across on-premises, hybrid, and Oracle-delivered exam workflows. Expect scenario-based questions on deployment and patching, multitenant administration, RMAN backup and recovery, performance analysis, and current Oracle AI Database features relevant to working DBAs.

Questions

65 scored questions

Time Limit

120 minutes

Passing Score

60%

Exam Fee

$245 USD (Oracle University / Oracle MyLearn)

Oracle DBA Exam Content Outline

15%

Deploy, Patch, and Upgrade Oracle Database

Install and configure Oracle Database, use DBCA and Oracle Net tooling, apply RU patches with OPatch and datapatch, run AutoUpgrade prechecks, and complete post-upgrade validation.

20%

Manage Multitenant Architecture

Administer CDB and PDB architecture, create and clone PDBs, manage common and local users, work with application containers, and control services and multitenant protections.

20%

Perform Backup and Recovery

Design RMAN backup strategies, manage the recovery catalog and fast recovery area, use ARCHIVELOG and flashback features, and execute complete, incomplete, duplicate, and migration-oriented recovery workflows.

25%

Manage and Tune Performance

Tune memory and workload behavior, interpret AWR, ASH, and ADDM findings, read execution plans and SQL Monitor output, maintain optimizer statistics, and use SQL tuning and plan-management features.

20%

Administer Current Oracle AI Database Features

Understand the DBA impact of current Oracle AI Database features such as vector search, JSON Relational Duality, True Cache, cross-platform RMAN migration, newer SQL capabilities, and security-oriented enhancements.

How to Pass the Oracle DBA Exam

What You Need to Know

Passing score: 60%
Exam length: 65 questions
Time limit: 120 minutes
Exam fee: $245 USD

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

Oracle DBA Study Tips from Top Performers

1Study by the official weighted domains, not by product feature lists. Performance tuning is the heaviest area, but multitenant, backup and recovery, and current AI Database features are each large enough to require dedicated prep.

2Build and rebuild a multitenant lab. Create, clone, unplug, plug, and refresh PDBs until the administrative flow feels routine.

3Practice RMAN restore and recovery under pressure. Many Oracle DBA mistakes come from knowing the theory but not the exact recovery sequence.

4Use AWR, ASH, ADDM, DBMS_XPLAN, and SQL Monitor together so you can move from symptom to diagnosis instead of memorizing each tool in isolation.

5Work through patching and upgrade workflows end to end, including OPatch inventory checks, datapatch, prechecks, and post-upgrade validation.

6Review current Oracle AI Database features from a DBA perspective. Focus on operational impact, privilege design, migration implications, and where a feature fits rather than only on developer syntax.

7Aim to score comfortably above 75% on mixed practice sets before scheduling. That gives you margin over Oracle's 60% passing threshold.

Frequently Asked Questions

What exam facts matter most for the current Oracle DBA professional track?

The current Oracle DBA professional blueprint uses 65 multiple-choice questions in 120 minutes with a 60% passing score. Oracle's U.S. Oracle Technology exam subscription page lists a single exam attempt at $245. This practice exam uses those current facts rather than older OCP-era assumptions.

Which domain is most important on the Oracle DBA exam?

Performance management and tuning is the largest publicly posted domain at 25%. That means you should expect substantial coverage of AWR, ASH, ADDM, wait-event interpretation, execution plans, optimizer statistics, and SQL tuning decisions.

Is this practice set closer to 1Z0-083 or the newer Oracle DBA professional exam?

It is intentionally closer to Oracle's current professional administration blueprint. Oracle still lists older version-specific exams in the certification catalog, but Oracle's April 2025 Oracle University announcement shifted attention to the Oracle Database 23ai Administration Professional path, and Oracle's 2026 Japan listings use the newer 26ai administration branding for the same modern DBA scope.

How much hands-on practice should I plan before scheduling?

Most candidates should plan on roughly 80 to 120 hours of study and lab work. Oracle DBA questions are easier when you have actually run DBCA, applied patches, created and cloned PDBs, taken RMAN backups, performed recovery drills, and read AWR or SQL Monitor output yourself.

Does Oracle deliver this exam online?

Yes, Oracle's current Oracle Technology exam workflow is Oracle-delivered through Oracle University and MyLearn for English-language technology exams. Oracle's support and FAQ pages also describe online scheduling, rescheduling, and cancellation in MyLearn, although some localized on-premises exam programs still have region-specific delivery differences.

What changed recently in Oracle DBA certification content?

The main recent shift is that Oracle's current professional administration blueprint explicitly includes modern Oracle AI Database features alongside the classic DBA pillars of deployment, multitenant administration, backup and recovery, and performance tuning. Oracle also stated in its 2025 announcement that it was not planning a separate 23ai performance-and-tuning exam, which makes the professional administration exam more comprehensive.