Multiple choice technology

MV threshold percentage can be set using the below statement

  1. SET MV DEFAULT MATERIALIZED [REFRESH] THRESHOLD <percentage>

  2. SET SYSTEM DEFAULT MATERIALIZED [REFRESH] THRESHOLD <percentage>

  3. SET SYSTEM DEFAULT [REFRESH] THRESHOLD <percentage>

  4. Any of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Netezza, the materialized view refresh threshold is set using SET SYSTEM DEFAULT MATERIALIZED REFRESH THRESHOLD. This system parameter controls what percentage of base table changes will trigger an automatic refresh of the materialized view. The SET MV DEFAULT syntax is incorrect.

Keep practicing — related questions