what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
Answer Posted / mkumar.it
Snapshots and Materialized view are used interchangibly as
both are almost same. However, materialized view is having
additional feature of query rewrite which is not in snapsot.
In this feature, suppose you made any materialized view
using some aggrigate function and you query base table from
sql using same aggrigate funtion, the query will execute on
the materialized view instead of querying base table
provided you have query rewrite priviledge.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What are the types of partitions in oracle?
Explain what does a control file contain?
What is bind variable in oracle 11g?
How to resolve name conflicts between variables and columns?
What are the limitations oracle database 10g xe?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to view the data files in the current database?
What privilege is needed for a user to delete rows from tables in another schema?
How do you store pictures in a database?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How do we get field detail of a table?
What are the database administrators utilities available?
What is save point in oracle database?
What is difference between truncate and delete?
Can the query output be sorted by multiple columns in oracle?