Oracle
1Z0-061 · Question #126
Examine the structure of the MARKS table: Which two statements would execute successfully? (Choose two.)
The correct answer is C. SELECT SUM(subject1+subject2+subject3) D. SELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1). See the full explanation below for the reasoning.
Question
Examine the structure of the MARKS table:
Which two statements would execute successfully? (Choose two.)
Exhibit
Options
- ASELECT student_name, subject1
- BSELECT student_name, SUM(subject1)
- CSELECT SUM(subject1+subject2+subject3)
- DSELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1)
How the community answered
(45 responses)- A16% (7)
- B11% (5)
- C73% (33)
Community Discussion
No community discussion yet for this question.