Ask a Question
Advertise on boostr.in
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.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please