questions - 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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.