Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
- 2 Answers
- 14275 Views
- I also Faced
- E-Mail Answers
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
How to select some rows from a table in oracle?
What is a subquery?
How can we delete duplicate rows in a table?
what are archived logs?
How to experiment a data lock in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to convert numbers to characters in oracle?
What is a private synonym?
What is a trigger and what are its types?
What is a table index in oracle?
How to drop an index in oracle?
What are named parameters?
Explain the use of show option in imp command.
Explain the function of optimizer in oracle?
How to use values from other tables in update statements using oracle?
