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)

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

987

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

---

explain the delete statements in sql

975

---

What is microsoft t sql?

880

---

What are the sql commands?

1094

---

What is the example of procedure?

873

---

Is mariadb a nosql database?

1004

---

What are stored procedures used for?

960

---

What is a procedure in pl sql?

1125

---

How to write html code in pl sql?

1054

---

Is sql considered coding?

991

---

What is dml and ddl?

897

---

what does it mean to have quoted_identifier on? : Sql dba

1098

---

Why do we need view in sql?

931

---

Is primary key a clustered index?

909

---