To maintain materialized view in RDBMS, we use –
2022
To maintain materialized view in RDBMS, we use –
Answer: A. Trigger — Materialized views store data physically and must be kept synchronized with the base tables. Triggers are commonly used to automatically update or maintain…
- A.
Trigger
- B.
Pointer
- C.
Clone object
- D.
None
Attempted by 100 students.
Show answer & explanation
Correct answer: A
Materialized views store data physically and must be kept synchronized with the base tables. Triggers are commonly used to automatically update or maintain materialized views when changes occur in the underlying tables. Hence, the correct answer is Trigger .
Loading lesson…