What is a SNAPSHOT ?
- 1 Answers
- 2339 Views
- I also Faced
- E-Mail Answers
Answer / nishi
Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.
| Is This Answer Correct ? | 0 Yes | 0 No |
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How do you tell what your machine name is and what is its IP address?
Point the difference between translate and replace?
List out the difference between commit, rollback, and savepoint?
How is it different from a normal table?
What happens if variable names collide with table/column names?
What is the quickest way to export a table to a flat file?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
master table and child table performances and comparisons in Oracle ?
What is the difference between a user and a schema in oracle?
Oracle General 
