Multiple choice technology databases

COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows

  1. Create

  2. Delete

  3. Append

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A complete refresh of a materialized view deletes all existing rows before inserting the new dataset. This differs from fast refresh (incremental) which only applies changes. The DELETE operation ensures the mview contains exactly the data from the refresh query, with no stale rows remaining.

Keep practicing — related questions