Interested to Buy Any Domain ? << Click Here >> for more details...
What is a materialised view?
- 5 Answers
- 8674 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / velmurugan uk
Materialised view is a snopshot/Copy of data(where data can
come out of select query) which can be refresed over a
period of time.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / deva
Its the data of the remote database. When we queried for
the data at the remote database/schema, the data/resuls set
is known as the materialized view.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / riddhi
1) view don't store data whereas mview contains copy of data
2) performance of mview is better then view
3)view contains updated data whereas mview not contain up to date Data because there is an activity of data refresh in mview
| Is This Answer Correct ? | 0 Yes | 0 No |
Describe an oracle table?
What is materialized view in Oracle?
How to download oracle database 10g xe?
What is a Tablespace?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
How to call a stored procedure inside a trigger? Give an example.
How to use in conditions in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
what is a Nested Loop join?
can a table has a column that has only view data and in other columns we can change data?
How to create id with auto_increment on oracle?
Oracle General 
