Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

How to convert characters to times in oracle?

954


What is a snapshot in oracle database?

971


Is insert autocommit in oracle?

1016


How to connect ms access to oracle servers?

944


State any two functions of oracle?

981


How to test null values?

1041


How to convert numbers to characters in oracle?

967


What are the different oracle database objects?

1030


How do I learn what codesets are available in oracle?

997


How can I introduce multiple conditions in like operator?

923


What is a table index in oracle?

1067


what is Single Byte Overhead...?

2498


How can I create database in oracle?

959


Can we create database in oracle using command line ?

1028


What exactly do quotation marks around the table name do?

916