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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is meant by Materialized view?

Question Posted / arasan500

Answers were Sorted based on User's Feedback



What is meant by Materialized view?..

Answer / raj&

materialized views are schema objects that can be used to summarize,precompute,replicate and distribute data.

Is This Answer Correct ?    4 Yes 1 No

What is meant by Materialized view?..

Answer / nitin

Materialized views are used to precompute a heavy joins instead of executing a joins again n again. Moreover it physically stores the data unlike views where it is conceptually. Materialized views can be refresh on timely manner.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How to display the current date in sql?

0 Answers  

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

what is inline view?

15 Answers  

What is the command used to fetch the first 5 characters of a string?

0 Answers  

What is the usage of nvl function?

0 Answers  

What is sql select statement?

0 Answers  

How many postgresql users are there, worldwide?

0 Answers  

What are the types of optimization?

0 Answers  

What is sql table?

0 Answers  

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

Is inner join faster than left join?

0 Answers  

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

For more SQL PLSQL Interview Questions Click Here
Categories