⟩ What is the functions of a load manager?
A load manager extracts data from the source system. Fast load the extracted data into temporary data store. Perform simple transformations into structure similar to the one in the data warehouse.
A load manager extracts data from the source system. Fast load the extracted data into temporary data store. Perform simple transformations into structure similar to the one in the data warehouse.
What is a Table space?
What does a Control file Contain?
What is Rollback Segment?
How do you define Data Block size?
What are the Characteristics of Data Files?
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?