OCP 1Z0 051 QUESTION NO: 57

QUESTION NO: 57 
 
Examine the structure of the MARKS table:
 
 
Exhibit: 
 

 
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; 
 
Answer: C,D

与正式题库109 重复

http://blog.csdn.net/jgmydsai/article/details/26847749