Answer Posted / rashid ansari
materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a cognitive schema?
What is oracle rowcount?
What are the uses of synonyms?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are the execution control statements in oracle?
How to define a variable to match a table column data type?
What is varray?
what is the difference between functional dependecy and multilevel dependency?
What are the uses of linked server and explain it in detail?
What privilege is needed for a user to create tables in oracle?
What is oracle join syntax?
Explain oracle’s server parameter file.
How to list all tables in your schema?
Explain the use of online redo log files in oracle.
What is proxy method?