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 are the types of dbms?

918

What is database white box testing and black box testing?

1045

How many sql databases can you have on one server?

1016

How many row comparison operators are used while working with a subquery?

972

How to find 3rd highest salary of an employee from the employee table in sql?

1034

What are procedures used for?

919

How do I enable sql encryption?

964

What is the difference between inner join and natural join?

951

how many tables will create when we create table, what are they? : Sql dba

1018

How to download oracle sql developer?

1054

What is the difference between nested table and varray?

938

Show the cursor attributes of pl/sql.

993

Why do we create stored procedures & functions in pl/sql and how are they different?

887

How to change sql*plus system settings?

992

What is orm in sql?

988