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
How to convert characters to times in oracle?
What is a snapshot in oracle database?
Is insert autocommit in oracle?
How to connect ms access to oracle servers?
State any two functions of oracle?
How to test null values?
How to convert numbers to characters in oracle?
What are the different oracle database objects?
How do I learn what codesets are available in oracle?
How can I introduce multiple conditions in like operator?
What is a table index in oracle?
what is Single Byte Overhead...?
How can I create database in oracle?
Can we create database in oracle using command line ?
What exactly do quotation marks around the table name do?