What is a SNAPSHOT ?
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 |
Is oracle the best database?
What is dictionary cache ?
What is the difference between a primary key & a unique key?
Explain the relationship among Database, Tablespace and Data file?
Give syntax for SQL and ORACLE joins.
What exactly do quotation marks around the table name do?
difference between truncate and delete ,drop?
sql query to get zero records from a table
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is the disadvantage of User defind function?
How to use windows user to connect to the server?
What is a view and how is it different from a table?