Interested to Buy Any Domain ? << Click Here >> for more details...
Explain materialized views and how they are used.
- 2 Answers
- 6263 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shams tabrez
Materialized views are dynamic views, means if materialized
were created on 2 tables than if any update happens in
these two tables than it reflect on materialized views
which is created on these 2 tables.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / shyamal mondal
Materialized view is a database object which contains the result of a query. It is the local copy of data located remotely or are used to create summary table based on aggregation of table's data.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to find locks exists in a table or not?
Are These Dff's Flexible?
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
How many segment are present in Oracle Manufacturing
Explain the difference between a data block, an extent and a segment.
Give two examples of how you might determine the structure of the table DEPT.
How do you switch from an init.ora file to a spfile?
Where in the Oracle directory tree structure are audit traces placed?
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
What is store procedure?and how do u take the values from database and run in scripts?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
Oracle General 
