View:
☛ Tail raid data representation is provided by a view to access data from its table.
☛ It has logical structure that does not occupy space.
☛ Changes get affected in corresponding tables.
Materialized view:
☛ Pre-calculated data persists in materialized view.
☛ It has physical data space occupation.
☛ Changes will not get affected in corresponding tables.
What is the function of Optimizer?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
What is a View?
What is Execution Plan?
What are the different approaches used by Optimizer in choosing an execution plan?
What is the difference between OLAP and OLTP?
What are data modeling and data mining? Where it will be used?
What is the difference between aggregate table and materialized view?
"A dimension table is wide but the fact table is deep," Explain the statement in your own words.
What is a data profile?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
