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.
Oracle SQL command:
select max(hire_date)
from employees;
Output:
21.04.2008
D is correct.
select MAXIMUM(hire_date)
from employees;
ORA-00904: “MAXIMUM”: invalid identifier
D is incorrect.