What is the differnce between view and materialized view
Answer Posted / papia
view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is a trigger in mysql? : Sql dba
What is %rowtype in pl sql?
What is exit statement?
How many primary keys can a table have?
What is the use of function in sql?
What are the benefits of triggers?
What are synonyms in sql?
What is normalization in a database?
Show the cursor attributes of pl/sql.
Are left and right joins the same?
What is on delete restrict?
When are we going to use truncate and delete?
Does truncate table reset auto increment?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is function and procedure?