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

create one table to capture an employee details with a primary key.

1 Answers   CTS,

What is a nested table and how is it different from a normal table?

0 Answers  

When can Hash Cluster used ?

1 Answers  

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

Explain the use of owner option in exp command.

0 Answers  

query to find the maximum no persons with same age(age colomn) from emp table

1 Answers  

Explain the blob datatype?

0 Answers  

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 Answers  

How to view the data files in the current database?

0 Answers  

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

0 Answers   Oracle,

What do you mean by redo log file mirroring?

0 Answers  

What to do if the startbd.bat failed to start the xe instance?

0 Answers