Answer / nivedita

view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.

Answer / yaswanth

A view will takes the output of the query. But a materialized
view stores the output of the query which is not possible in
view

Answer / suresh babu

View:view is a logical table,it don't have own data,the
query which we mentioned after the create view statement
will be compiled and stored in server as a database
object.once we call the view,the compiled query will be
fetch the data from master table.
The DML operations will be reflected in master table or
view suddenly.
Materialized view:The Materialized view required physical
memory space.it will be created from target master
table,which located in some other location.A materialized
view can be created either single mater table or multimater
tables from multiple master sites.the changes which we have
done in master table will reflect in particular interval
time.the materialized view,which created from multiple
master tables,will updated its individual batch files....

Answer / papia

view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.

how can i read files from a pl/sq l program

3 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

what is bulk bind

4 Answers   TCS,

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

how to convert character strings to dates? : Sql dba

0 Answers  

---

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

---

Explain constraints in sql?

0 Answers  

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

What is dcl in sql?

0 Answers  

---