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 can you do with pl sql?

766

---

Name three sql operations that perform a sort.

786

---

Explain aggregate functions are available there in sql?

750

---

What operating systems are supported by oracle sql developer?

714

---

What is the difference between database trigger and stored procedure?

738

---

---

What is graph sql?

719

---

How many commands are in sql?

716

---

Explain raise_application_error.

828

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

729

---

Do stored procedures prevent sql injection?

725

---

tell me about various levels of constraint. : Sql dba

754

---

Explain exception handling in pl/sql?

725

---

How do you use a while loop in pl sql?

717

---

Explain isolation levels. : Transact sql

743

---

Is join and inner join the same?

724

---