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 are the differences between char and nchar? : Sql dba

0 Answers  

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

What kind of join is join?

0 Answers  

can we update a view which is created from two tables

11 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

What does (*) mean in sql?

0 Answers  

explain normalization concept? : Sql dba

0 Answers  

What is sql profiler in oracle?

0 Answers  

Can a varchar be a primary key?

0 Answers  

Show code of a cursor for loop.

0 Answers  

What do you understand by pl/sql cursors?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories