OCP 23ai New Features Practice Question
In 23ai, when using the 'JSON relational duality' feature, how are changes to the JSON document propagated to the underlying tables?
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
✓
Automatically propagated by the database
Updates made via JSON Duality Views are transparently propagated to the underlying relational tables using the view's defined mapping.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Only allowed via stored procedures
Why it's wrong here
Direct updates are supported.
- ✓
Automatically propagated by the database
Why this is correct
This is the core value proposition of Duality Views.
- ✗
Manual re-synchronization
Why it's wrong here
No manual sync is needed.
- ✗
Requires a trigger
Why it's wrong here
Duality views handle this automatically.
About these practice questions
This OCP question is part of Courseiva's 312-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 OCP 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 OCP exam.