VIEWS: Takes the output of a query M.VIEWS: Stores the output of a query,

Difference between views and materialized views?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to use sql statements in pl/sql?

1122

How to add new employee details in an employee_details table with the following details

1091

What is indexing oracle sql?

1106

What is offset and limit in sql?

1059

What is sql profiler in oracle?

1095

What are different clauses used in sql?

1115

What is the difference between an inner join and an outer join?

1027

Can a key be both primary and foreign?

995

what is collation? : Sql dba

1156

Can we write dml inside a function in sql server?

953

How to avoid duplicate records in a query?

1008

What is an example of translating a date into julian format?

1124

How many types of keys are there in sql?

1040

Name the operator which is used in the query for pattern matching?

954

what is a foreign key ? : Sql dba

1084