What is a common aggregation function used to calculate the average of a dataset?
- AVERAGE
- AVG
- MEAN
- TOTAL
The common aggregation function used to calculate the average of a dataset in SQL is AVG. It calculates the average value of a numeric column, providing a measure of central tendency for the data.
Loading...
Related Quiz
- One of the key features of column-family stores is their ability to handle _______ workloads efficiently.
- Which dimension change type in SCD involves creating a new record for each change, thus preserving historical data?
- What are some advantages and disadvantages of using inheritance in database modeling?
- What are some common challenges faced during collaborative data modeling projects?
- Scenario: A financial institution needs to ensure data consistency across its distributed database partitions. What techniques or mechanisms can be employed to achieve this while maintaining high availability?