Oracle to Postgres Migration: Schema Mapping & Data Types Quiz Home › PostgreSQL DBA › Oracle to Postgres Migration: Schema Mapping & Data Types 🔁 Postgres Database Administration – Oracle to Postgres Migration: Schema Mapping & Data Types 20 questions · 15 min timer · Explanations included · Free 1. What is a common challenge when migrating Oracle's hierarchical queries to PostgreSQL? Using recursive CTEs Using subqueries Using window functions Using array functions None 1 out of 20 2. Which PostgreSQL feature can be used to emulate Oracle's PL/SQL packages? Schemas Functions and Procedures Extensions Triggers None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!