Differentiate simple and complex, snapshots ?
ORACLE Interview Questions and Answers (Part 1)
(Continued from previous question...)
111. Differentiate simple and complex, 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.
(Continued on next question...)
Other Interview Questions