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. Do Nothing
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 data set. This differs from FAST REFRESH, which only applies incremental changes. The DELETE operation ensures no stale data remains.

Keep practicing — related questions