Multiple choice technology programming languages

Which oracle object provides access to table data by storing the results of a query in a separate schema object ?

  1. view

  2. materilized view

  3. undo segments

  4. flashback
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A materialized view is a database object that stores the results of a query physically, unlike a regular view which is just a stored query. Materialized views can improve query performance by pre-computing expensive joins and aggregations, and can be refreshed on schedule or on demand.

Keep practicing — related questions