1Z0-997-26 Workload Migration Practice Question
During a database migration assessment from an on-premises Oracle Database (version 11.2.0.4) to OCI Base Database Service running Oracle Database 19c, you discover that the legacy database uses deprecated initialization parameters and character sets that are incompatible with 19c. How should you address this migration blocker?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Run the Pre-Upgrade Information Tool (utlu19i.sql) on the source database, remediate reported issues, upgrade the database binaries locally, and then migrate using Oracle Data Pump or RMAN.
Upgrading across multiple major versions (11.2 to 19c) requires reviewing upgrade paths, deprecations, and character set conversions. Oracle Data Pump or transportable methods along with the Database Upgrade Assistant (DBUA) or Pre-Upgrade Information Tool must be run on the source database to identify and remediate incompatibilities before migration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Perform a direct binary block-level copy of the 11.2.0.4 datafiles to OCI and start the 19c instance using the old parameter file.
Why it's wrong here
Binary block copying across major versions with different internal data dictionary structures will corrupt the database.
- ✗
Migrate the database to an OCI Autonomous Database directly, as Autonomous Database automatically converts any legacy version and character set on the fly.
Why it's wrong here
Autonomous Database has strict version and character set prerequisites and will reject incompatible source databases.
- ✓
Run the Pre-Upgrade Information Tool (utlu19i.sql) on the source database, remediate reported issues, upgrade the database binaries locally, and then migrate using Oracle Data Pump or RMAN.
Why this is correct
Running pre-upgrade checks, fixing deprecated parameters and character sets, and using supported upgrade paths ensure a successful migration.
- ✗
Use OCI GoldenGate to stream the 11.2.0.4 data directly into a 19c target database without any schema adjustments.
Why it's wrong here
GoldenGate requires compatible database structures and data types; structural deprecations between 11g and 19c will cause replication failures.
About these practice questions
This 1Z0-997-26 question is part of Courseiva's 344-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Oracle exam blueprint
This 1Z0-997-26 practice question is part of Courseiva's free Oracle certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the 1Z0-997-26 exam.