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

Explain what is a column in a table?

1156

How many parts of a pl sql block are optional?

1216

What is the purpose of normalization?

1085

What is sqlcommand?

1071

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1286

How do I debug a stored procedure?

1161

What are different types of functions in sql?

1051

Explain the order of sql statement execution?

1087

What is sqlerrm?

983

What is audit logout in sql profiler?

1073

What are the different types of database management systems?

1036

How can we store rows in PL/SQL using array?

1267

What is the best sql course?

1026

Is it possible for a table to have more than one foreign key?

1079

What is the purpose of the primary key?

1117