Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 48 of 50

Marks: +1, -0

Examine the structure of the MARKS table:

Which two statements would execute successfully? (Choose two.)

SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) FROM marks WHERE subject1 > subject2;
SELECT student_name subject1 FROM marks WHERE subject1 > AVG(subject1);
SELECT SUM(subject1+subject2+subject3) FROM marks WHERE student_name IS NULL;
SELECT student_name,SUM(subject1) FROM marks WHERE student_name LIKE ‘R%’;

Go to Question:

Prev Question

Next Question