Oracle Security Interview Question:

Differentiate the simple and complex, snapshots?

Submitted by: Administrator

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.
Submitted by: Administrator