PCDE Migrate data solutions Practice Question
A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. They have used Ora2Pg to convert the schema. Which of the following data type conversions is correct?
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
✓
Oracle CLOB → PostgreSQL TEXT
Oracle's DATE includes both date and time, so the correct mapping is to PostgreSQL TIMESTAMP. NUMBER(10) maps to INTEGER, NUMBER(10,2) to NUMERIC(10,2), and CLOB to TEXT.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Oracle NUMBER(10) → PostgreSQL NUMERIC(10)
Why it's wrong here
NUMBER(10) without scale is integer-like, maps to INTEGER.
- ✓
Oracle CLOB → PostgreSQL TEXT
Why this is correct
CLOB is large character object, maps to TEXT.
- ✗
Oracle NUMBER(10,2) → PostgreSQL INTEGER
Why it's wrong here
NUMBER(10,2) has decimal places, should map to NUMERIC(10,2).
- ✗
Oracle DATE → PostgreSQL DATE
Why it's wrong here
Oracle DATE includes time; PostgreSQL DATE does not.
Go deeper
Related to this question
About these practice questions
One of 1,446 original PCDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PCDE practice question is part of Courseiva's free Google Cloud 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 PCDE exam.