Which two statements would execute successfully?

Examine the structure of the MARKS table:

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

Examine the structure of the MARKS table:

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

A.
SELECT student_name,subject1
FROM marks
WHERE subject1 > AVG(subject1);

B.
SELECT student_name,SUM(subject1)
FROM marks
WHERE student_name LIKE ‘R%’;

C.
SELECT SUM(subject1+subject2+subject3)
FROM marks
WHERE student_name IS NULL;

D.
SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)
FROM marks
WHERE subject1 > subject2;



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Bina

Bina

Ans C and D
A is wrong because where clause does not include group function.
B needs to be group by student_name.

filavander

filavander

A is wrong because “group function is not allowed here”
B is wrong because of lack “group by student_name”

kiya

kiya

Filavander you clear my confusion..tnx