What term describes saving a view as an actual physical table?

What term describes saving a view as an actual physical table?

• A. View Materialized
• B. Catalog
• C. Authentication
• D. Backup

Answer: (A)

Saving a view as a physical table is a materialized view. A regular view is just a saved query that is executed each time you query it and doesn’t store data. A materialized view, on the other hand, keeps the result set on disk like a table, so reads from it can be much faster since the expensive computations aren’t repeated every time. The catch is that the data can become out of date as the underlying tables change, so you need to refresh the materialized view to bring it up to date. Refreshes can be done in whole or, in some systems, incrementally. The other terms don’t describe this behavior: a catalog is metadata about database objects, authentication is about verifying identity, and backup is a copy of data for recovery. The concept that matches saving a view as a physical table is materialized view.

Saving a view as a physical table is a materialized view. A regular view is just a saved query that is executed each time you query it and doesn’t store data. A materialized view, on the other hand, keeps the result set on disk like a table, so reads from it can be much faster since the expensive computations aren’t repeated every time. The catch is that the data can become out of date as the underlying tables change, so you need to refresh the materialized view to bring it up to date. Refreshes can be done in whole or, in some systems, incrementally.

The other terms don’t describe this behavior: a catalog is metadata about database objects, authentication is about verifying identity, and backup is a copy of data for recovery. The concept that matches saving a view as a physical table is materialized view.