What is the difference between view and materialized view?

Correct Answer: View: - Tail raid data representation is provided by a view to access data from its table - It has logical structure can not occupy space - Changes get affected in corresponding tables Materialized view - Pre calculated data persists in materialized view - It has physical data space occupation - Changes will not get affected in corresponding tables