Answer Posted / guru

View: View is a virtual table, a query attached to it.
Actually it have not Stored query results. It will execute
and returns rows.

A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.A materialized view can query tables, views, and
other materialized views. Collectively these are called
master tables (a replication term) or detail tables (a data
warehouse term)

Explain the the update statement in sql?

1036

---

What are the usages of sql?

1058

---

What is pl sql collection?

969

---

What is the purpose of primary key?

1026

---

What is coalesce in sql?

1057

---

What is full join in sql?

991

---

What is asqueryable?

967

---

what is the use of friend function? : Sql dba

1023

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1156

---

What are the rules to be applied to nulls whilst doing comparisons?

1323

---

How many types of relationship are there?

1031

---

What is normalisation and its types?

1004

---

What is a pl/sql block?

1226

---

what is single byte over head in oracle..?

2401

---

which operator is used in query for pattern matching? : Sql dba

1005

---