Multiple choice technology databases

The data contained in Materialized view will be deleted automatically if the base tables will be deleted?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Materialized views store actual data physically, unlike regular views which are just stored queries. When base tables are dropped, the materialized view's data remains in storage. The view may become invalid or unusable, but the data is not automatically deleted. The statement is false.