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 a materialised view?

Answer Posted / rashid ansari

materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe an oracle table?

1050


What is procedure overloading in oracle?

1061


Where do we use decode and case statements?

1013


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2145


How to specify default values in insert statement using oracle?

1105


How to create a new view in oracle?

1078


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2291


What is columnar storage what is the advantage?

1064


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022


What is an oracle function?

1166


What is memory advisor in Oracle?

1077


Which is better Oracle or MS SQL? Why?

6388


Explain the use of rows option in exp command.

1093


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1787


How to rebuild an index in oracle?

1028