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.)

technology databases

  1. SUM(start_date)

  2. AVG(start_date)

  3. COUNT(start_date)

  4. AVG(start_date, end_date)

  5. MIN(start_date)

  6. MAXIMUM(start_date)

Show answer
Correct Option: C,E

AI Explanation

To determine which two aggregate functions are valid on the START_DATE column, let's go through each option:

A. SUM(start_date) - This option is incorrect because the SUM function is used to calculate the sum of numeric values, not dates.

B. AVG(start_date) - This option is incorrect because the AVG function is used to calculate the average of numeric values, not dates.

C. COUNT(start_date) - This option is correct because the COUNT function can be used to count the number of occurrences of a column, including dates.

D. AVG(start_date, end_date) - This option is incorrect because the AVG function can only be used on a single column, not multiple columns.

E. MIN(start_date) - This option is correct because the MIN function can be used to find the minimum value in a column, including dates.

F. MAXIMUM(start_date) - This option is incorrect because there is no MAXIMUM function in SQL. The correct function is MAX, which can be used to find the maximum value in a column, including dates.

Therefore, the two valid aggregate functions on the START_DATE column are:

C. COUNT(start_date) E. MIN(start_date)

The correct answer is C and E.

Find more quizzes: