EDB Postgres Advanced Server (EPAS): Oracle Compatibility Features Quiz

Home › PostgreSQL DBA › EDB Postgres Advanced Server (EPAS): Oracle Compatibility Features
🏢 Postgres Database Administration – EDB Postgres Advanced Server (EPAS): Oracle Compatibility Features
20 questions  ·  15 min timer  ·  Explanations included  ·  Free

EPAS exists so Oracle applications can run on Postgres without being rewritten. This quiz covers which Oracle constructs it reproduces and how — genuinely hard material to find practice questions for anywhere.

What this quiz covers

  • ROWNUM — how EPAS handles a pseudocolumn Postgres doesn’t have
  • Oracle functions — NVL, TO_DATE, and the compatibility layer behind them
  • Synonyms — Oracle-style object aliasing
  • Packages and autonomous transactions — the PL/SQL constructs community Postgres lacks
  • Oracle-style triggers, user-defined types and VARRAYs
  • Materialized views — the EPAS behaviour
  • EDB*Plus — the SQL*Plus equivalent
  • EDB*Loader — the SQL*Loader equivalent, including control file handling

Common mistakes

  • Assuming EPAS compatibility features work identically in community PostgreSQL — most of these don’t exist there
  • Expecting a migration to be automatic because EPAS is compatible; compatibility narrows the gap, it doesn’t close it
  • Relying on ROWNUM in new code rather than LIMIT

Twenty questions below, each with an explanation.

1. 
In EDB Postgres Advanced Server, which feature allows for the use of Oracle-style REF CURSORs?

1 out of 20
Scroll to Top