To maintain materialized view in RDBMS, we use –

2022

To maintain materialized view in RDBMS, we use –

  1. A.

    Trigger

  2. B.

    Pointer

  3. C.

    Clone object

  4. D.

    None

Attempted by 27 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 .

Explore the full course: Niacl Ao It Specialist