What is the behavior of the STDDEV() function in DB2 when applied to a column with NULL values?
- It returns NULL
- It returns 0
- It returns 1
- It returns error
The correct option is 1. The STDDEV() function in DB2 returns NULL when applied to a column with NULL values. It does not include NULL values in the calculation of standard deviation.
Loading...
Related Quiz
- Which normal form ensures that there are no repeating groups in a table?
- In DB2, a cursor is primarily used to process ________.
- Scenario: A data analyst needs to generate reports from a DB2 database that involve traversing result sets in both forward and backward directions. How can they achieve this efficiently using cursors in DB2?
- In high availability setups, the primary goal is to minimize ________ in case of a system failure.
- Describe the process of auditing in DB2 and its importance in ensuring security.