Answer Posted / 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 ...;

Explain normalization and what are the advantages of it?

953

---

What is rowtype?

1021

---

Does sql view stored data?

959

---

what are the join types in tsql? : Transact sql

1064

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060

---

What are the subsets of sql?

1134

---

What is the difference between nested table and varray?

1003

---

Describe different types of general function used in sql?

1038

---

how to rename an existing table in mysql? : Sql dba

1064

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3050

---

Are subqueries better than joins?

976

---

What are stuff and replace function?

1083

---

What are aggregate and scalar functions?

1025

---

What are pl/sql packages?

1102

---

Is sql a programming?

978

---