Differentiate simple and complex, snapshots ?
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 dictionary tables used to monitor a database spaces ?
What is Auditing ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the different Levels of Auditing ?
what is the step for rmanbackup?
What are the various type of snapshots ?
what is meant by physical order and logical order in clustered index and non clustered index.
What is a profile ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
what is different between view and sequence?
What are the responsibilities of a Database Administrator ?
What are the benefits of distributed options in databases ?