what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
Answer Posted / its me...
A materialized view is a database object that contains the
results of a query. The FROM clause of the query can name
tables, views, and other materialized views. Collectively
these objects are called master tables .
materialized views allow you to maintain copies of remote
data on your local node.
You can select data from a materialized view as you would
from a table or view.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is an oracle?
How do I know if oracle client is installed on windows?
Explain an index?
What is the usage of synonyms?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain about integrity constraint?
What is the best way to do multi-row insert in oracle?
Explain table?
What is the difference between substr & instr functions?
How to write a left outer join with the where clause in oracle?
What is the difference between post-database commit and post-form commit?
How do I recompile a procedure in oracle?
How to use null as conditions in oracle?
How do we represent comments in oracle?
What is tns entry?