The AVG() function in DB2 calculates the ________ of the values in a numeric column.
- Mean
- Median
- Mode
- Sum
The correct option is 1. The AVG() function in DB2 calculates the arithmetic mean of the values in a numeric column, which is the sum of all values divided by the count of values. This provides the average value.
Loading...
Related Quiz
- What are some features of DB2 that enhance performance tuning?
- Which type of lock in DB2 allows multiple transactions to read data but prevents them from modifying it?
- What is the difference between CHAR and VARCHAR data types in DB2?
- How does DB2 handle indexes on columns with high cardinality?
- Which DB2 command is used to restore a database from a backup?