Differentiate simple and complex, snapshots ?
- 2 Answers
- 4190 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
- 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
- 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the use of Roles ?
What is Tablespace Quota ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the system resources that can be controlled through Profile ?
what is different between view and sequence?
How to prevent unauthorized use of privileges granted to a Role ?
What dynamic data replication ?
What is Object Auditing ?
what is the step for rmanbackup?
How can you enable automatic archiving ?
What is default tablespace ?
what is snapshot log ?
Oracle General 
