READ Free Dumps For Oracle- 1z1-051
Question ID 4920 | What is true of using group functions on columns that contain NULL values? |
Option A | A. Group functions on columns ignore NULL values. |
Option B | B. Group functions on columns returning dates include NULL values. |
Option C | C. Group functions on columns returning numbers include NULL values. |
Option D | D. Group functions on columns cannot be accurately used on columns that contain NULL values. |
Option E | E. Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS. |
Correct Answer | A |
Question ID 4921 | The STUDENT_GRADES table has these columns: |
Option A | A. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL; |
Option B | B. SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL; |
Option C | C. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end; |
Option D | D. SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades; |
Option E | E. SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL; |
Correct Answer | C |