Interested to Buy Any Domain ? << Click Here >> for more details...
Explain materialized views and how they are used.
- 2 Answers
- 6382 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shams tabrez
Materialized views are dynamic views, means if materialized
were created on 2 tables than if any update happens in
these two tables than it reflect on materialized views
which is created on these 2 tables.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / shyamal mondal
Materialized view is a database object which contains the result of a query. It is the local copy of data located remotely or are used to create summary table based on aggregation of table's data.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between the SQL*Loader and IMPORT utilities?
can we drop dual table
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
key flexfield structure
what is semphore explian it?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
When creating a user, what permissions must you grant to allow them to connect to the database?
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
what is correlated subquery
Are These Dff's Flexible?
what is the difference b/w oracle8i and oracle9i
Explain prerequisites and post activities of oracle database installation
Oracle General 
