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 the differnce between view and materialized view

Answer Posted / papia

view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a trigger in mysql? : Sql dba

1151


What is %rowtype in pl sql?

994


What is exit statement?

1020


How many primary keys can a table have?

1013


What is the use of function in sql?

1098


What are the benefits of triggers?

1175


What are synonyms in sql?

976


What is normalization in a database?

1162


Show the cursor attributes of pl/sql.

1054


Are left and right joins the same?

1091


What is on delete restrict?

1005


When are we going to use truncate and delete?

991


Does truncate table reset auto increment?

1002


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1006


What is function and procedure?

1037