Oracle Distributed Processing Question:

Download Job Interview Questions and Answers PDF

Differentiate simple and complex, oracle snapshots?

Distributed Processing Interview Question
Distributed Processing 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.

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?