Difference between views and materialized views?
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 |
Post New Answer View All Answers
What are the types of dbms?
What is database white box testing and black box testing?
How many sql databases can you have on one server?
How many row comparison operators are used while working with a subquery?
How to find 3rd highest salary of an employee from the employee table in sql?
What are procedures used for?
How do I enable sql encryption?
What is the difference between inner join and natural join?
how many tables will create when we create table, what are they? : Sql dba
How to download oracle sql developer?
What is the difference between nested table and varray?
Show the cursor attributes of pl/sql.
Why do we create stored procedures & functions in pl/sql and how are they different?
How to change sql*plus system settings?
What is orm in sql?