What is difference between View and Materialised views?

Question

Accepted Answer

Views are virtual tables while Materialized views are physical tables.

Views are created using SELECT statement while Materialized views are created using CREATE MATERIALIZED VIEW statement.
Views are not stored physically while Materialized views are stored physically.
Views are updated dynamically while Materialized views are updated manually or using a scheduled job.
Materialized views are faster for read-intensive operations while Views are faster for write-intensive operations.
Example of View: SELECT * FROM employees WHERE department = 'Sales';
Example of Materialized view: CREATE MATERIALIZED VIEW sales_employees AS SELECT * FROM employees WHERE department = 'Sales';

Top Access Infotech Oracle Database Administrator interview questions & answers