Answer / narenkumar reddy

Mv is database object it contain the data stored physically
from select stmt of query
first time it will get the data base table next time onwards
based on refresh methods mv are created tables and views and
also mv
there three types of refresh methods
1.complete(the whole query execute)
2.fast(only modified records are updated target table i.e
incremental loading)
3.force(some times means when we r using agg function on
that time fast option is not working so we go for force option)

Answer / dinesh

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table.

CREATE MATERIALIZED VIEW view-name
BUILD [IMMEDIATE | DEFERRED]
REFRESH [FAST | COMPLETE | FORCE ]
ON [COMMIT | DEMAND ]
[[ENABLE | DISABLE] QUERY REWRITE]
[ON PREBUILT TABLE]
AS
SELECT ...;

Why do we use triggers?

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

How are sql commands classified?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

What is sql not null constraint?

0 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

What is the left table in sql?

0 Answers  

---

What is the use of count (*) in sql?

0 Answers  

---

What is microsoft t sql?

0 Answers  

---