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 |
what is trigger?
how to find full database size
1 Answers BirlaSoft, Consultancy,
Where are the settings stored for each instance in oracle?
List the types of joins used in writing subqueries?
What are the common oracle dba tasks?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain an extent?
How to retrieve data from an explicit cursor?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the data pump import utility?
What is an Oracle view?
How to check your oracle database 10g xe installation?