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 do you explain an index?

1275

---

how to start mysql server? : Sql dba

1188

---

What is pivot table in sql?

1091

---

what is a primary key? : Sql dba

1029

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1024

---

when MSQL8.0 is in market

2067

---

How do you respond to dementia behavior?

961

---

Explain what is table in a database?

1050

---

what is an index? : Sql dba

983

---

What is sql injection owasp?

1049

---

What are three advantages to using sql?

999

---

Which is better stored procedure or query?

953

---

Is stored procedure faster than query?

961

---

Do we need to rebuild index after truncate?

1023

---

What is trigger explain with example?

1021

---