ocp 11g考試題庫詳解：1Z0-051-109題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g考試題庫詳解：1Z0-051-109題，完整題庫請點擊這里聯系老師咨詢了解
109. Examine the structure of the MARKS table:
name Null Type
STUDENT_ID NOT NULL VARCHAR2(4)
STUDENT_NAME VARCHAR2(25)
SUBJECT1 NUMBER(3)
SUBJECT2 NUMBER(3)
SUBJECT3 NUMBER(3)
Which two statements would execute successfully? (Choose two.)
A. SELECT student_name,subject1
FROM marks
WHERE subject1 > AVG(subject1); where不能跟表達式
B. SELECT student_name,SUM(subject1)
FROM marks
WHERE student_name LIKE 'R%'; 少了group by
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: CD
試題解析：
A答案：AGV分組函數不能用在where子句里
B答案：缺少group by
C答案：因為測試數據里沒有student_name沒有為空的，所有無返回值。
