Interested to Buy Any Domain ? << Click Here >> for more details...
Explain materialized views and how they are used.
- 2 Answers
- 6471 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 are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is mrc and what is its use? : oracle accounts receivable
What does coalescing a tablespace do?
What is the difference between oracle media recovery and crash recovery?
Explain about party and customer in ar : oracle accounts receivable
What are different types of transactions in ar? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
How would you determine the time zone under which a database was operating?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How do you use trigger to create mutating state of table
What is the difference between recovery and restoring of the oracle database?
Oracle General 
