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 privilege is needed for a user to create indexes in oracle?
When do you get a .pll extension in oracle?
What are the general rules on data consistency?
What is merge statement used for?
What is Redo Log Buffer in Oracle?
How is it different from a normal table?
Explain the use of owner option in exp command.
How can we find out the duplicate values in an oracle table?
How to call a stored function with parameters?
What is the string concatenation operator in oracle?
Why use resource manager in Oracle?
State and explain about oracle instance?
Why do you use stored procedures and state some of its disadvantages?
Explain the difference between a procedure and a function?
Explain the use of record option in exp command.
