What is a SNAPSHOT ?
Answer / nishi
Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you mean by redo log file mirroring?
What is the difference between sharding and partitioning?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What are the type of Synonyms?
What is Read-Only Transaction ?
What are the different types of databases?
Explain implicit cursor.
Give the various exception types.
What is autonomous transaction?
What do you know about normalization? Explain in detail?
What are the limitations of check constraint?