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 |
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What is a Private Synonyms ?
How to use "if" statements on multiple conditions?
what is the difference between first normal form & second normal form?
When do I need to use a semicolon vs a slash in oracle sql?
What are set operators?
What is materialized view in Oracle?
How many categories of data types in oracle?
What are the uses of linked server and explain it in detail?
Can we call a trigger inside a function and function inside a trigger? Give example.
What is the difference between "as" and "is" in an oracle stored procedure?
Explain the use of indexes option in exp command.