Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are different types of refreshment techniques of
materialised view

Question Posted / venkateswarareddy

Answers were Sorted based on User's Feedback



What are different types of refreshment techniques of materialised view..

Answer / 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

What are different types of refreshment techniques of materialised view..

Answer / rajesh venati

The above one good,
There are Three Types of Refreshment Techniques in
Materialized View.
They are,

1. Fast Refresh
2. Force Refresh
3. Complete Refresh

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can we use rowid as primary key?

0 Answers  

What are different types of sql?

0 Answers  

What is the difference between in and between in sql?

0 Answers  

- 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?

0 Answers   CTS,

Compare SQL and PL/SQL.

3 Answers  




How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

What are packages in pl sql and also explain its advantages?

0 Answers  

What is an alias command?

0 Answers  

What does rownum mean in sql?

0 Answers  

What is the benefit of foreign key?

0 Answers  

Explain what is an index?

0 Answers  

What is the use of primary key?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories