Dynamic and materialized view
Write a short note on the difference between a dynamic and materialized view?
Expert
A dynamic view might be created every time that a particular view is requested by a user. A materialized view is created and updated infrequently and it should be synchronized with its associated base table(s).
What is meant by the parameter file?
Briefly describe the five elements of an Information Systems Architecture and their relationship to data.
Elucidate briefly what is batch and also give explanation about the types of batches?
What does it mean when we say that a relation is in Boyce-Codd Normal Form (BCNF)?
Explain the following terms: Proactive, Retroactive and immediate Update.
Explain the Rank, Router, Sorter transformation?
Explain how in a relation a supertype or subtype is mapped?
Explain the function of metadata for the three-layer architecture?
Explain the following term: a) ROLAP b) MOLAP
Describe truncate commands.
18,76,764
1926922 Asked
3,689
Active Tutors
1461717
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!