Computer Science · Structured Query Language
A relational database table contains NULL values in a numeric column. What is the result of applying the SUM() aggregate function to this column?
- 1It returns a NULL value regardless of other numbers.
- 2It includes NULL values by treating them as zero.
- 3It raises a runtime execution error.
- 4It completely ignores the NULL values and sums the remaining numbers.✓
Correct answer
It completely ignores the NULL values and sums the remaining numbers.
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Structured Query Language?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Structured Query Language