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)

How many types of primary keys are there?

1078

---

how to get help information from the server? : Sql dba

985

---

How many unique keys can a table have?

1065

---

Is sql procedural language?

1010

---

What is fmtonly in sql?

1159

---

Is join same as left join?

1080

---

What is the difference between delete and truncate statement in sql?

1122

---

What is sql injection vulnerability?

1005

---

Which kind of parameters cannot have a default value in pl sql?

1204

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1141

---

What is rownum?

1032

---

What's the difference between a primary key and a clustered index?

1023

---

What is the difference between numeric and autonumber?

1036

---

What is a stored procedure in sql with example?

1197

---

What are pl/sql cursor exceptions?

1162

---