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
How to set up autotrace for a user account?
What are operators in oracle?
How to rename a tablespace in oracle?
State the various uses of dbcc command?
What is max rowid in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to delete a column in an existing table?
Is insert autocommit in oracle?
what is the dual table in oracle?
What do you mean by merge in oracle?
What is a tns file?
What are the original export and import utilities?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the use of file param in imp command?
Explain the different normalization forms?
