is that anyone who can help me in this question 1.What is the purpose of a Mater

Question

is that anyone who can help me in this question

1.What is the purpose of a Materialized View log? Are they always required? Why or why not?

2.A materialized view log is required for all types of materialized views.

True

False

3.A materialized view is built as an 'on-demand' MV. Let's say it's built on a query using Course & Section using an inner join. A new Course record is added to the Course table. The governing transaction is committed. Does the new row exist in the MV?

True

False

4.A materialized view is built as an 'on-commit' MV. Let's say it's built on a query using Course & Section using an inner join. A new Course record is added to the Course table. The governing transaction is committed. Does the new row exist in the MV?

True

False

5.You can create b-tree indexes on MVs?

True

Fals

Explanation / Answer

1)Answer:

A materialized view log is required on a master if we want to fast refresh materialized views based on the master. When we create a materialized view log for a master table or master materialized view, Oracle creates an underlying table as the materialized view log. A Mview log can hold the primary keys, rowids, or object ids of rows, or both, that have been updated in the master table or master materialized view. A materialized view log can also contain other columns to support fast refreshes of materialized views with subqueries.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.