Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
Experts Most Trusted Topic
Question:Which of the following statements are true regarding materialized views?
a. ¬†¬†¬†¬†¬†¬†¬†Materialized views cannot be partitioned, nor can they be defined on partitioned tables
b. ¬†¬†¬†¬†¬†¬†¬†Materialized views are often used in data warehouses to increase the speed of queries on very large datatables
c. ¬†¬†¬†¬†¬†¬†¬†Queries that benefit from the use of materialized views often involve joins between tables or aggregations such as SUM
d. ¬†¬†¬†¬†¬†¬†¬†A materialized view stores both the definition of a view and the rows resulting from the execution of the views
e. ¬†¬†¬†¬†¬†¬†¬†Materialized views can be used to replicate data, which was formerly achieved using the CREATE SNAPSHOT statement
Sep 13, 2013
Sep 12, 2013
to add a comment.
Related Hot Questions
Government Jobs Opening