Oracle
1Z0-071 · Question #190
Examine the structure of the MARKS table: Which two statements would execute successfully? (Choose two.)
The correct answer is A. SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) C. SELECT SUM(subject1+subject2+subject3). See the full explanation below for the reasoning.
Question
Examine the structure of the MARKS table:
Which two statements would execute successfully? (Choose two.)
Options
- ASELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)
- BSELECT student_name subject1
- CSELECT SUM(subject1+subject2+subject3)
- DSELECT student_name,SUM(subject1)
How the community answered
(51 responses)- A82% (42)
- B12% (6)
- D6% (3)
Community Discussion
No community discussion yet for this question.