Sign Up Login


  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

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

Why is %isopen always false for an implicit cursor?

0 Answers  

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

How do I copy a table in sql?

0 Answers  




Which data type is a composite type?

0 Answers  

Explain polymorphism in pl/sql.

0 Answers  

what is a trigger in mysql? : Sql dba

0 Answers  

What is the max nvarchar size?

0 Answers  

What are local and global variables and their differences?

0 Answers  

Is keyword pl sql?

0 Answers  

Can variables be used in sql statements?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories