Give 2 similarities between Materialized views and indexes.
Ch 41: Views Continued & Transactions Overview
Examines enforcing view integrity during updates via WITH CHECK OPTION, transition to transaction concepts, and logical units of work.
5 Questions5 MCQs0 Short Questions0 Long Questions
SEMESTER PASS
CS403 - Database Management Systems Examination Practice
Timed practice exam simulation for CS403 - Database Management Systems.
Showing 1 – 5 of 5 Questions
Page 1 of 1
Give two similarities between Materialized Views and physical database indexes.
Materialized views and physical indexes are database optimization structures. State four operational and physical similarities between Materialized Views and standard indexes in database management systems.
Materialized views are schema objects that can be used to summarize, compute, and distribute data. Give two operational similarities between Materialized views (or indexed views) and standard physical database indexes.
Describe the ways in which Materialized Views are operationally similar to standard database indexes.