Oracle Distributed Processing Question:
Download Questions PDF

Differentiate simple and complex, oracle snapshots?

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.

Download Distributed Processing Interview Questions And Answers PDF

Previous QuestionNext Question
What is an Oracle SQL * NET?How can you Enforce Referential Integrity in oracle snapshots?