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
Describe an oracle table?
What is procedure overloading in oracle?
Where do we use decode and case statements?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to specify default values in insert statement using oracle?
How to create a new view in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is columnar storage what is the advantage?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is an oracle function?
What is memory advisor in Oracle?
Which is better Oracle or MS SQL? Why?
Explain the use of rows option in exp command.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to rebuild an index in oracle?