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 is sql server agent? : Sql dba

599

---

Explain isolation levels. : Transact sql

573

---

What is the difference between jpql and sql?

551

---

what are date and time data types in mysql? : Sql dba

495

---

What are stored procedures used for?

531

---

---

Can we use pl sql in mysql?

513

---

How exception is different from error?

539

---

What is the process of debugging?

546

---

How to pronounce postgresql?

574

---

Explain what is a view?

591

---

What is difference between mysql and postgresql?

509

---

What is nvarchar in sql?

518

---

what is a primary key? : Sql dba

552

---

How do I view a procedure in sql?

545

---

how to convert dates to character strings? : Sql dba

533

---