Oracle 1Z0-1094-26 Real Exam Questions [October 2026 Update]

The central architectural decision in any Oracle database cloud migration – one the exam tests in every major scenario – is the choice between online migration (the database stays available throughout the migration, with a brief cutover window at the end) and offline migration (the database is shut down for the duration of the migration). This is not just a technical choice; it is a business decision driven by the application’s tolerable downtime window. An organisation with a 24-hour maintenance window available can use Data Pump export/import or RMAN backup-and-restore – straightforward, well-understood tools with predictable behaviour. An organisation with a two-hour maintenance window must use Oracle Zero Downtime Migration (ZDM) in online mode – running continuous Data Guard or GoldenGate replication during migration and cutting over in minutes rather than hours. The exam tests this decision framework as a scenario-matching exercise: given a described application availability requirement and a described database size, select the migration method that satisfies the requirement.

Zero Downtime Migration’s two operational modes are the most frequently confused topic on the exam – and the confusion has practical consequences because the wrong mode selection in production causes exactly the downtime ZDM is supposed to prevent. ZDM Physical Migration uses RMAN incremental backups to replicate the source database to the target – the data files are copied using RMAN, and then Data Guard redo log shipping keeps the standby current. This mode is fast for large databases (RMAN backup speeds), preserves all database characterset and features exactly (no conversion), and achieves near-zero RPO at cutover because Data Guard has been receiving redo continuously. ZDM Logical Migration uses Data Pump to export from the source and import into the target, with GoldenGate replicating ongoing changes. This mode can migrate across database charactersets and versions – useful when the target is Autonomous Database, which may be on a newer Oracle Database version. The exam tests which mode to select given the described migration constraints.

The Autonomous Database migration path adds a third layer of decision-making that the exam specifically covers: before migrating any database to Autonomous Database, the Oracle Pre-migration Advisor must be run against the source database to identify incompatibilities. Autonomous Database restricts certain database features and object types that standard Oracle Database allows – SYS-owned objects, certain parameter settings, unsupported object types – and the Pre-migration Advisor produces a report categorising each finding as BLOCKAGE (must be resolved before migration can proceed), ERROR (will cause migration failure), or WARNING (will not block migration but should be reviewed). The exam tests the Pre-migration Advisor output categories as a required pre-migration step, not as optional due diligence.

Exam Snapshot

What This Certification Validates

An Oracle Cloud Database Migration and Integration Professional has the expertise to migrate Oracle Database instances from on-premises environments or other clouds to Oracle Cloud Infrastructure – including to Oracle Base Database Service, Exadata Database Service, and Autonomous Database. The certification covers the selection of migration strategy, the use of Oracle and OCI migration tools, execution of the migration workflow, post-migration validation, and data integration patterns that connect migrated databases with other enterprise systems.

Domain 1: Migration Strategy and Planning

Migration assessment: Before selecting a migration tool or method, a migration assessment analyses the source database – inventorying object types, database features in use, size (data volume, database file count), application availability requirements, and any compliance or data residency constraints. The assessment output determines the migration path.

Target database selection: The target on OCI can be Base Database Service (VM or BM DB System for a lift-and-shift – same database version, same OS, minimal compatibility risk), Autonomous Database (fully managed, requires compatibility validation), or Exadata Database Service (for databases requiring Exadata-level performance). The exam tests target selection as a scenario-driven decision based on the source database’s size, performance requirements, and the amount of management overhead the customer wants to retain.

Online vs. offline migration choice:

Offline migration: The source database is shut down (or placed in restricted mode) for the entire migration duration. Data Pump export/import, RMAN backup-and-restore, or database cloning are offline methods. Suitable when a maintenance window exceeds the estimated migration duration.

Online migration: The source database remains available throughout migration, with only a brief cutover window. Requires continuous replication (ZDM with Data Guard or GoldenGate). Required when downtime windows are too short for offline methods.

Domain 2: Migrating Using RMAN, Data Pump, and Cloning

RMAN backup-and-restore migration: RMAN creates a full backup of the source database, the backup files are transferred to OCI Object Storage or directly to the target OCI host, and RMAN restores and recovers the database to the target environment. This is a proven, reliable offline migration method appropriate for databases where a maintenance window covers the backup+restore cycle. The exam tests RMAN migration as the correct method when direct connectivity exists between source and OCI and when a full database copy (not schema-level) migration is required.

Data Pump (expdp/impdp): Data Pump performs a logical export of database objects – schemas, tables, indexes, constraints, packages – into a dump file, then imports the dump file into the target database. Data Pump is schema-level, not full-database – it migrates logical objects rather than physical data files. This makes it suitable for migrating specific schemas to a new target while leaving others behind, or for migrating across different Oracle Database versions (exporting from 12c, importing into 19c). The exam tests Data Pump as the correct method for schema-selective migration, cross-version migration, or migration to Autonomous Database where the source is smaller and downtime is acceptable.

Cloning to OCI Base Database Service: OCI’s Base Database Service supports creating a new DB System from a backup – restoring an on-premises RMAN backup into a new OCI DB System. This “backup-based provisioning” creates the target environment and migrates data in a single operation. The exam tests backup-based provisioning as a simplified RMAN migration path for Base Database targets.

Oracle Database Cloud Backup Service: The Oracle Database Cloud Backup Module (the OCI Object Storage backup plugin for RMAN) allows RMAN to back up directly to OCI Object Storage from on-premises environments – eliminating the need to stage backup files on an intermediate server. Backups written to OCI Object Storage can then be restored into OCI DB Systems. The exam tests the Cloud Backup Module as the connectivity component that links on-premises RMAN to OCI Object Storage.

Domain 3: Migrating Using SQL Developer, Cloud Backup, and GoldenGate

SQL Developer migration: Oracle SQL Developer’s Migration Workbench supports migrating databases from non-Oracle sources (Microsoft SQL Server, MySQL, Sybase) to Oracle Database – converting the DDL, migrating data, and translating stored procedures. For Oracle-to-Oracle migrations, SQL Developer can be used for simpler schema migrations but is generally not the preferred tool for large-volume production migrations.

Oracle GoldenGate for migration: GoldenGate captures change data from the source database’s redo logs (LogMiner-based extraction) and replicates those changes to the target database in real time. GoldenGate supports: Oracle-to-Oracle replication (same version or across versions), Oracle-to-Autonomous Database replication, and cross-platform replication (Oracle to non-Oracle targets). In a migration context, GoldenGate is combined with an initial load (Data Pump or RMAN bulk load) to populate the target, then GoldenGate replication catches up the target with changes made during the bulk load – enabling online migration with minimal cutover downtime. The exam tests GoldenGate as the continuous change replication component in online migration workflows.

GoldenGate vs. Data Guard: Data Guard is a database-level HA/DR technology that replicates at the redo log level – it requires the source and target to be the same Oracle Database version and on compatible platforms. GoldenGate operates at the transaction level – it can replicate across Oracle Database versions and platforms. The exam tests this distinction: when cross-version or cross-platform replication is needed, GoldenGate is correct; when same-version, same-platform standby replication is needed, Data Guard is correct.

Domain 4: Oracle Zero Downtime Migration (ZDM)

ZDM overview: ZDM is Oracle’s automation toolkit for performing online migrations of Oracle Database to OCI with near-zero downtime. ZDM automates the full migration workflow – source preparation, data transfer, replication setup, validation, and cutover – through a command-line interface (zdmcli) that runs on a dedicated ZDM service host.

ZDM Physical Migration (Data Guard-based):

Initial data transfer: ZDM uses RMAN to copy the source database to the target (either via OCI Object Storage as an intermediary or directly over the network).

Redo log shipping: After the initial RMAN copy, ZDM configures Data Guard between the source (primary) and target (standby) – the standby continuously applies redo logs from the primary, keeping the target current with source changes.

Cutover: When the migration is ready, ZDM performs the Data Guard switchover – the target becomes the new primary and the source becomes the standby (or is decommissioned). The cutover window is typically minutes – only the time required for the switchover and application connection redirection.

Best for: Same-version migrations, large databases (RMAN is faster than logical export for very large databases), and migrations where characterset conversion is not needed.

ZDM Logical Migration (GoldenGate-based):

Initial data transfer: ZDM uses Data Pump to export and import data into the target database.

GoldenGate replication: ZDM configures Oracle GoldenGate to capture changes from the source during and after the Data Pump load – keeping the target synchronised with ongoing source transactions.

Cutover: When GoldenGate lag approaches zero (the target is caught up with the source), the cutover redirects applications to the target and GoldenGate replication is stopped.

Best for: Migrations to Autonomous Database (which may be on a newer Oracle version), cross-version migrations, or migrations requiring characterset conversion.

ZDM key commands tested:

zdmcli migrate database: Initiates the migration workflow with specified source, target, and migration options.

zdmcli query job: Monitors the status of an in-progress migration job – showing the current phase and any errors.

zdmcli abort job: Stops an in-progress migration job – used when a critical error is encountered during migration.

Common ZDM troubleshooting scenarios:

Replication lag not decreasing during GoldenGate-based migration: Typically caused by insufficient GoldenGate extract throughput – the source generates changes faster than GoldenGate can replicate. Resolution: scale GoldenGate Extract processes or reduce source workload before cutover.

RMAN backup failing during ZDM Physical Migration: Check network connectivity between source and OCI Object Storage (if using Object Storage as intermediary), or verify source database RMAN compatibility settings.

Domain 5: Migrating to Autonomous Database

Pre-migration Advisor: Before migrating any source database to Autonomous Database, the Oracle Pre-migration Advisor must be run. It analyses the source database and produces a categorised finding report:

BLOCKAGE: A finding that will prevent migration from completing. Must be resolved before migration begins.

ERROR: A finding that will cause migration failure at a specific step. Must be resolved.

WARNING: A finding that will not block migration but may indicate a compatibility issue to be reviewed post-migration.

The exam tests the Pre-migration Advisor as a mandatory first step – candidates who proceed to migration without running it fail the migration workflow questions.

Autonomous Database compatibility restrictions: Autonomous Database restricts certain Oracle Database features: SYS/SYSTEM schema modifications are not permitted, certain initialisation parameters cannot be changed, external tables requiring OS filesystem access are not supported, network access from PL/SQL must use database credentials or ACLs. The Pre-migration Advisor identifies which of these restrictions apply to the source database’s objects and configurations.

Migrating to ADB using Data Pump: For smaller databases, Data Pump expdp creates a dump file from the source, the dump file is staged in OCI Object Storage, and impdp (or the Autonomous Database Data Pump import process via Database Actions) imports the dump into the ADB instance. The ADB import process handles tablespace mapping automatically – the source’s tablespace structure is mapped to ADB’s single-tablespace model.

Domain 6: Post-Migration Validation

Validation types:

Row count validation: Comparing row counts of major tables between source and target – a quick sanity check that data was not truncated during migration.

Data comparison: Using Oracle Data Compare or custom SQL scripts to compare actual data values between source and target – detecting any data corruption or transformation errors.

Application smoke testing: Running a representative set of application transactions against the migrated target to confirm that application behaviour is correct.

Performance validation: Running the application’s critical SQL workload on the target and comparing execution plans and response times to the source baseline – detecting performance regressions introduced by the migration.

Post-migration optimisation: After migration to Autonomous Database, Automatic Indexing analyses the workload and may create or drop indexes different from those on the source. Performance Hub shows real-time performance data that can be compared to pre-migration baselines to identify regressions requiring manual intervention (SQL Plan Management, hints, or index creation).

5 Study Tips for Oracle 1Z0-1094-26

• Study the online vs. offline migration decision framework – given an application availability requirement and database size, identify which migration method (ZDM online, Data Pump offline, RMAN offline) satisfies the requirement. This is the most common scenario question type.
• Study ZDM Physical Migration (RMAN + Data Guard) versus ZDM Logical Migration (Data Pump + GoldenGate) as two distinct modes with different use cases – know when each is the correct choice.
• Study the three ZDM key commands (migrate database, query job, abort job) and their purposes – the exam presents operational scenarios that require identifying the correct zdmcli command.
• Study the Pre-migration Advisor output categories (BLOCKAGE, ERROR, WARNING) and know that running it is a mandatory first step before any Autonomous Database migration.
• Practice with Cert Empire’s 1Z0-1094-26 exam questions covering all six domain areas at online/offline migration decision-making, ZDM mode selection, and Pre-migration Advisor output category depth.

Best Study Resources

• Cert Empire 1Z0-1094-26 exam questions PDF and practice simulator (October 2026 edition).
• Oracle official 1Z0-1094-26 exam page (education.oracle.com – search “1Z0-1094-26”).
• Oracle Zero Downtime Migration documentation (docs.oracle.com/en/database/oracle/zero-downtime-migration/).
• Oracle Pre-migration Advisor documentation (docs.oracle.com/en/cloud/paas/autonomous-database/).
• Oracle University: Oracle Cloud Database Migration and Integration course.

Why Candidates Choose Cert Empire for Oracle 1Z0-1094-26 Preparation

Free Practice Tests

Sample our 1Z0-1094-26 questions before purchasing. Test your online vs. offline migration decision reasoning, ZDM mode selection knowledge, and Pre-migration Advisor output understanding before committing.

Regular Updates

Oracle updates ZDM and migration tools with each quarterly OCI release. Our 1Z0-1094-26 question bank is continuously reviewed against current Oracle migration documentation and exam objectives.

Free Exam Guides

Every purchase includes our free 1Z0-1094-26 exam guide covering all six domain areas, the migration method decision tree, the ZDM mode comparison reference, and a structured study plan.

PDF Exam Questions – Study Anywhere, Anytime

Download your 1Z0-1094-26 questions instantly after purchase. Study on any device or print the PDF. No login required after download, no expiry on the file.

24/7 Chat Support

Available at any hour for questions about your materials, your order, or specific Oracle migration concepts – including ZDM command options, GoldenGate lag troubleshooting, and Pre-migration Advisor blockage resolution.

3 Months of Unlimited Access

Three full months of unlimited access to the 1Z0-1094-26 question bank and simulator. Revisit migration method scenarios, ZDM physical vs. logical questions, and post-migration validation topics as many times as needed.

Official Vendor Resources – Learn from the Source

Every solution in our 1Z0-1094-26 question bank links directly to the relevant official Oracle documentation – the ZDM user guide, Oracle Database migration guide, or the specific Oracle documentation behind the answer.

Deep Knowledge – Every Answer, Every Option, Fully Explained

Every 1Z0-1094-26 question includes a complete explanation covering not just why the correct migration method, ZDM mode, or validation type is right, but precisely why each incorrect option fails – whether it uses Data Guard for a cross-version migration where GoldenGate is needed, applies ZDM Logical where Physical is the correct mode for a same-version large database, or skips the Pre-migration Advisor before attempting an ADB migration. Each explanation references the specific Oracle migration documentation behind the answer.

Interactive Practice Simulator – Think Like the Exam

Our simulator presents Oracle database migration scenarios exactly as the real 1Z0-1094-26 exam does – describing an application availability requirement, a database size, and a target platform, then testing which migration method, ZDM mode, or validation approach correctly addresses all stated constraints. Per-question feedback explains the full database migration reasoning behind every correct and incorrect option.

Backed by a Full Money-Back Guarantee

If our 1Z0-1094-26 exam questions do not help you pass, you receive a full refund – no questions asked, no conditions.

FAQ’s

What is the Oracle 1Z0-1094-26 certification?

1Z0-1094-26 is the Oracle Cloud Database Migration and Integration 2026 Professional exam. It validates expertise in migrating Oracle Database to OCI – covering migration strategy and tool selection, RMAN, Data Pump, cloning, GoldenGate, Oracle Zero Downtime Migration, Autonomous Database migration, and post-migration validation.

What is the difference between ZDM Physical Migration and ZDM Logical Migration?

ZDM Physical Migration uses RMAN backup and Data Guard redo log shipping – copying data files and synchronising via redo. It is best for same-version large database migrations with no characterset conversion. ZDM Logical Migration uses Data Pump for the initial load and GoldenGate for ongoing change replication – supporting cross-version migration and migration to Autonomous Database.

When should I use GoldenGate instead of Data Guard for migration replication?

Use GoldenGate when the source and target are different Oracle Database versions, when the target is Autonomous Database (which may be on a newer version), or when the migration requires cross-platform replication. Data Guard requires the same Oracle Database version and compatible platforms – it is not suitable for cross-version migration.

What is the Pre-migration Advisor and why is it required for Autonomous Database migration?

The Pre-migration Advisor analyses the source database for features and objects that are incompatible with Autonomous Database. It categorises findings as BLOCKAGE (must be fixed before migration), ERROR (will cause migration failure), or WARNING (should be reviewed but will not block migration). Running it is a mandatory first step – proceeding without it risks hitting unidentified blockers mid-migration.

What are the three key zdmcli commands tested on the exam?

zdmcli migrate database initiates the migration workflow. zdmcli query job monitors the status and current phase of an in-progress migration job. zdmcli abort job stops an in-progress migration job when a critical error requires intervention.

What is the Oracle Database Cloud Backup Module?

The Cloud Backup Module is an RMAN backup plugin that allows on-premises RMAN to write backups directly to OCI Object Storage – without staging on an intermediate server. Backups written to OCI Object Storage can then be restored directly into OCI DB Systems, simplifying the RMAN-based migration path.

What is the passing score for the 1Z0-1094-26 exam?

The passing score is 68%. The exam is multiple-choice format delivered through Pearson VUE either online-proctored or at a test centre. The cost is USD $245.

Related Certifications Worth Exploring

Oracle Cloud Database Migration professionals building a complete OCI credential portfolio will find the Oracle 1Z0-183 (Oracle Database 23ai Administration Professional) exam questions page covers advanced database administration – architecture, storage, security, backup and recovery, performance management, and high availability skills that provide essential source and target database knowledge for migration projects. For those managing the OCI infrastructure and operational environment that migrated databases run on, the Oracle 1Z0-1067-26 (OCI Cloud Operations Professional 2026) exam questions page covers infrastructure deployment, monitoring, automation, security, availability, troubleshooting, and business continuity skills that support reliable production database workloads after migration.