Question: what are materialised views in oracle?
Answer: A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and other materialized views. ... In replication environments, the materialized views commonly created are primary key, rowid, object, and subquery materialized views.