You need to calculate the total of all salaries in the accounting department. Which group function should you use?

The correct answer is C. SUM. Function SUM(x) calculates the sum of all values in column x in all rows returned by the SELECT Incorrect Answers A: Function MAX(x) determines the maximum value in column x for all rows returned by the SELECT statement. B: Function MIN(x) determines the minimum value in column…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Options

AMAX
BMIN
CSUM
DCOUNT
ETOTAL
FLARGEST

How the community answered

(26 responses)

A
4% (1)
B
8% (2)
C
77% (20)
D
12% (3)

Explanation

Function SUM(x) calculates the sum of all values in column x in all rows returned by the SELECT Incorrect Answers A: Function MAX(x) determines the maximum value in column x for all rows returned by the SELECT statement. B: Function MIN(x) determines the minimum value in column x for all rows returned by the SELECT statement. D: Function COUNT(x) counts the number of non-NULL values returned by the SELECT statement for column x. E: There is no TOTAL() function in Oracle. F: There is no LARGEST() function in Oracle.

Topics

#SUM function#group functions#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice