Answer / velmurugan uk

Materialised view is a snopshot/Copy of data(where data can
come out of select query) which can be refresed over a
period of time.

Answer / rashid ansari

materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.

Answer / deva

Its the data of the remote database. When we queried for
the data at the remote database/schema, the data/resuls set
is known as the materialized view.

Answer / riddhi

1) view don't store data whereas mview contains copy of data
2) performance of mview is better then view
3)view contains updated data whereas mview not contain up to date Data because there is an activity of data refresh in mview

Answer / amme singh

rashid ansari ans is right

How to find the date and time of last updated table?

4 Answers  

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  

How can you Enforce Referential Integrity in snapshots ?

1 Answers  

Will you be able to store pictures in the database?explain.

0 Answers  

Difference between hot backup vs. Cold backup?

0 Answers  

How to drop an index in oracle?

0 Answers  

What are the restrictions on external table columns?

0 Answers  

What do you mean by group by clause?

0 Answers  

What is a Tablespace?

5 Answers  

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

How to define a data source name (dsn) in odbc manager?

0 Answers  

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,