interview question by Tech Mahindra

[vivekmcm]

(1)What Materialized View and when we create it
 and where we create on local machine or  remote machine
(2) How many  types of Materialize view
(3) how can we refresh materialize view every 2hr

 pls  give me example


 

[dtech-team]

This is a commonly asked question. I have explained it with an example here: http://www.oraclepassport.com/Materialized%20Views.html

Please read and let me know if you have more questions.

Thanks.

[debrah.h48]

Hope you will get detail information about Materialized View here: http://download.oracle.com/docs/cd/B10501_01/server.920/a96567/repmview.htm