Examine the description of the STUDENTS table: Which two aggregate functions are valid on the START_DATE column? (Choose two)

The correct answer is C. COUNT (start_date) E. MIN (start_date). It is possible to apply COUNT() and MIN() functions on the column with DATE data type. Incorrect Answers A: Function SUM() cannot be used with DATE data type column. B: Function AVG() cannot be used with DATE data type column. D: Function AVG() cannot be used with DATE data…

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

Question

Examine the description of the STUDENTS table:

Which two aggregate functions are valid on the START_DATE column? (Choose two)

Options

ASUM (start_date)
BAVG (start_date)
CCOUNT (start_date)
DAVG (start_date, end_date)
EMIN (start_date)
FMAXIMUM (start_date)

How the community answered

(49 responses)

A
12% (6)
B
2% (1)
C
78% (38)
D
6% (3)
F
2% (1)

Explanation

It is possible to apply COUNT() and MIN() functions on the column with DATE data type. Incorrect Answers A: Function SUM() cannot be used with DATE data type column. B: Function AVG() cannot be used with DATE data type column. D: Function AVG() cannot be used with DATE data type column. And function AVG() just has one parameter X, not two. It averages all X column values returned by the SELECT statement. F: There is no MAXIMUM() function in Oracle, only MAX() function exists.

Topics

#aggregate functions#DATE column aggregation#COUNT#MIN on dates

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice