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

What is a crud api?

956

What are the types of views in sql?

1108

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1041

How can I tell if sql is running?

1073

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1230

What are the types of queries in sql?

1089

how to drop an existing index in mysql? : Sql dba

1074

What is the difference between cross join and natural join?

1035

What is difference between hql and sql?

1087

What is right join sql?

969

what are enums used for in mysql? : Sql dba

1177

how to get a list of all tables in a database? : Sql dba

982

What is the difference between python and sql?

1013

Can we join two tables without common column?

1020

What is lexical units in pl sql?

1155