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 Materialized View? In What Scenario we Use
Materialized View?

Question Posted / praveengnr

Answers were Sorted based on User's Feedback



What is Materialized View? In What Scenario we Use Materialized View?..

Answer / chandan kumar

The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.

We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.

Is This Answer Correct ?    6 Yes 0 No

What is Materialized View? In What Scenario we Use Materialized View?..

Answer / thanigesan.m

view is a virtual table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also same
like the view but it exist in rdbms.
we use materialized view
e.g if we r having a table with 4 columns
empno ename sal comm
33 xxxy 1000 234
we can create a materialized view as totalsal by sum that 2
columns....

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is sqlca in powerbuilder?

0 Answers  

What is a unique constraint?

0 Answers  

What is trigger in pl sql?

0 Answers  

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

How to process query result in pl/sql?

0 Answers  

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

how to do backup entire database? : Transact sql

0 Answers  

What is benefit of creating memory optimized table?

0 Answers  

What is sharding in sql?

0 Answers  

How do I remove duplicates in two columns?

0 Answers  

What is cross join sql?

0 Answers  

Can we rollback after truncate?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories