What are different types of refreshment techniques of
materialised view
Answer Posted / ankush seth
three types of refreshment techniques for materialised
view
1)Fast refresh
2)Force refresh
3)Complete refresh
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain the structure of pl/sql in brief.
what is query cache in mysql? : Sql dba
What is the difference between microsoft access and sql?
how to shutdown mysql server? : Sql dba
Difference between table function and pipelined function?
How to install oracle sql developer?
What are the topics in pl sql?
What are the two different parts of the pl/sql packages?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is primary key in db?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is row_number () in sql?
What are stuff and replace function?
Are stored procedures faster than queries?
Explain the types of joins in sql?