Oracle Security Question:

Differentiate the simple and complex, snapshots?

Oracle Security Interview Question
Oracle Security Interview Question

Answer:

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.


Previous QuestionNext Question
What is dynamic data replication?Do you know What are the various type of snapshots?