Question: what are materialized views in oracle?
Answer: A materialized view is a database object that contains the results of a query. ... You can select data from a materialized view as you would from a table or view. In replication environments, the materialized views commonly created are primary key, rowid, object, and subquery materialized views.