Multiple choice

The ____________ are the views that get continuously updated even while the database is open or in use.

  1. materialized views

  2. dynamic performance views

  3. oracle view

  4. Both (1) and (2)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Materialized views can be set to continuously refresh even while the database is open and active through the ON COMMIT refresh option. Dynamic performance views (V$ views) are updated continuously as well, but the question specifies 'views' in the context of stored data objects. 'Oracle view' is not a standard category name. Option A is correct as materialized views are designed to maintain pre-computed results with ongoing refresh capabilities.

Keep practicing — related questions