Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / riddhi
1) view don't store data whereas mview contains copy of data
2) performance of mview is better then view
3)view contains updated data whereas mview not contain up to date Data because there is an activity of data refresh in mview
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are bitmap indexes? How does they work?
What is the recommended interval at which to run statspack snapshots, and why?
What is the use of aggregate functions in oracle?
What is different types of joins?
Explain oracle data types with examples?
How to work with data objects interactively?
What are the various types of snapshots ?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to export your own schema?
What are the different types of trigger and explain its various uses and functions?
Explain constraining triggers.
What are the limitations oracle database 10g xe?
Which environment variables are absolutely critical in order to run the OUI?
Please explain drop constraint oracle?
How to invoke the data pump export utility?
