view is a virtual table.view does not contain any data while material view

What is the differnce between view and materialized view

Question Posted / nivedita

Answer Posted / 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.

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is oracel sql developer written in java?

1060

which types of join is used in sql widely? : Sql dba

930

Is grant a ddl statement?

855

What is before and after trigger?

893

how do you tune the slow running queries in oracle db , explain the methodology

2072

What is sql dialect?

1039

What does an inner join do?

1092

What is sql not null constraint?

983

What are aggregate and scalar functions?

978

What is primary key secondary key alternate key candidate key?

982

what are the properties and different types of sub-queries? : Sql dba

969

Which is faster truncate or drop?

983

Can we create view in stored procedure?

910

What is pivot table in sql?

1019

Enlist some predefined exceptions?

998