Which two aggregate functions are valid on the START_DATE column?

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHAR2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column? (Choose two.)

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHAR2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column? (Choose two.)

A.
MIN(start_date)

B.
SUM(start_date)

C.
COUNT(start_date)

D.
MAXIMUM(start_date)

E.
AVG(start_date)

F.
AVG(start_date, end_date)

Explanation:

It is possible to apply COUNT() and MIN() functions on the column with DATE data type.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Igor

Igor

Oracle SQL command:

select max(hire_date)
from employees;

Output:
21.04.2008

D is correct.

dames

dames

select MAXIMUM(hire_date)
from employees;

ORA-00904: “MAXIMUM”: invalid identifier

D is incorrect.