An SQL developer is asked to develop a set of performance monitoring reports. The development team has decided to code the reports using derived tables to aggregate the system performance reports.
Which three are benefits of using a derived table in the report coding process? (Choose three.)
- Data distribution will be controlled by defining the primary index.
- The derived tables will be defined in the Data Dictionary for reuse.
- SQL coding will take fewer steps than using temporary table solutions.
- The temporary data will be available after the SQL request has completed.
- Column data types will be automatically defined except for casting requirements.
- The derived tables will not require the use of temporary space for materialization.
Reveal Solution
Next Question