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 sharding in sql?

0 Answers  

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

What is the difference between join and union.

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

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

What is sqlexception in java?

0 Answers  

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

how many groups of data types? : Sql dba

0 Answers  

What is an inner join sql?

0 Answers  

how to extract a unit value from a date and time? : Sql dba

0 Answers  

Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

For more SQL PLSQL Interview Questions Click Here
Categories