Oracle ETL Interview Question:

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

Submitted by: Administrator

Materialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB.But In materialized View data is stored in some temp tables.
Submitted by: Administrator