Oracle
1Z0-007 · Question #129
The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than 3.0 for the…
The correct answer is C. SELECT student_id, gpa. See the full explanation below for the reasoning.
Question
The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?
Options
- ASELECT student_id, gpa
- BSELECT student_id, gpa
- CSELECT student_id, gpa
- DSELECT student_id, gpa
- ESELECT student_id, gpa
How the community answered
(36 responses)- A3% (1)
- B3% (1)
- C75% (27)
- D8% (3)
- E11% (4)
Community Discussion
No community discussion yet for this question.