Oracle Distributed Processing Interview Questions and Answers

 

Differentiate simple and complex, oracle snapshots?

? A simple snapshot is based on a query that does not contains GROUP BY clauses,
CONNECT BY clauses, JOINs, sub-query or snashot of operations.


? A complex snapshots contain atleast any one of the above.

Posted by:Richards