What is a materialised view?

Answer Posted / 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.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1533


Explain oracle’s server parameter file.

572


How can you merge two tables in oracle?

571


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2050


How to enter a new row into a table interactively?

552






Is oracle an operator?

536


Explain the characteristics of oracle dba?

638


How to install oracle database 10g xe?

569


Is postgres faster than oracle?

561


What is sequence?

625


What is the best way to do multi-row insert in oracle?

567


Explain how you would restore a database using RMAN to Point in Time?

1641


What is a synonym? What are its various types?

625


How to start your 10g xe server from command line?

550


How to define a cusotmer as a supplier in ORACLE R12

1728