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 sql and its types?

625

What is a constraint?

565

Explain isolation levels. : Transact sql

575

What is the difference between left join and right join?

500

Does view store data in sql?

530

Is delete faster than truncate?

543

Can pl sql procedure have a return statement?

548

Does asenumerable execute the query?

594

What are dml commands?

524

What is AUTH_ID and AUTH_USER in pl/sql ?

1690

List different type of expressions with the example.

546

what are the types of subquery? : Sql dba

584

What are the 3 modes of parameter?

675

What does count (*) do in sql?

523

What type of database is cloud sql?

576