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 does joining a thread mean?

0 Answers  

Does oracle roll back the transaction on an error?

0 Answers  

what is d diff between grant,commit,rollback n savepoint

1 Answers  

explain advantages of myisam over innodb? : Sql dba

0 Answers  

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

what is rdbms? : Sql dba

0 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

What are the packages in pl sql?

0 Answers  

Explain the structure of pl/sql in brief.

0 Answers  

Write the order of precedence for validation of a column in a table ?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories