23/c
SCOTT>>SELECT department "Departments", MAX(salary) "Top Salaries"
2 FROM employee
3 WHERE department IN(200, 300, 400)
4 GROUP BY Departments
5 HAVING MAX(salary) > 60000;
HAVING MAX(salary) > 60000
*
ERROR 位于第 5 行:
ORA-00904: "SALARY": 无效的标识符
SCOTT>>SELECT department "Departments", MAX(salary) "Top Salaries"
2 FROM employee
3 WHERE department IN(200, 300, 400)
4 GROUP BY Departments
5 HAVING MAX(salary) > 60000;
HAVING MAX(salary) > 60000
*
ERROR 位于第 5 行:
ORA-00904: "SALARY": 无效的标识符
22.--d
23---c
24---c
25---c
26---c
27---a
28---a
29---a
30---d
同意bzszp(www.bzszp.533.net)
回复人: freddy2003() ( ) 信誉:88 2004-08-02 15:00:00 得分: 0
C,D,C,C,C,C,A,A,A,D 意见不符为:
22,25,28
set serveroutput on;
declare a boolean;b boolean;c boolean;
begin
a:=true;
b:=null;
c:= a or b;
if c =true then
dbms_output.put_line('true');
elsif c = null then
dbms_output.put_line('NULL');
else
dbms_output.put_line('else');
end if;
end;/*
truePL/SQL 过程已成功完成。
*/
看来答案应为A True
AND salary <= 30000;
不知道是不是写错了,估计是>=3000
28我测试了一下 答案是A
15:26:34 SQL> DECLARE
15:27:10 2 v_bonus BOOLEAN;
15:27:10 3 v_raise BOOLEAN;
15:27:10 4 v_issue_check BOOLEAN;
15:27:10 5
15:27:10 6 BEGIN
15:27:10 7 V_BONUS:=TRUE;
15:27:10 8 V_RAISE:=NULL;
15:27:10 9 v_issue_check := v_bonus OR v_raise;
15:27:10 10 IF V_ISSUE_CHECK THEN
15:27:10 11 DBMS_OUTPUT.PUT_LINE('TRUE');
15:27:10 12 ELSE
15:27:10 13 DBMS_OUTPUT.PUT_LINE('FALSE');
15:27:10 14 END IF;
15:27:10 15 END;
15:27:10 16 /
TRUEPL/SQL 过程已成功完成。已用时间: 00: 00: 00.32
15:27:11 SQL>
21、AC
22、B
23、D
24、E
25、AC
26、C
27、?
28、A
29、?
30、?
不好意思,现在不能跟您透漏这个公司的名字。
世界500强吧。
22 A
23 C
24 C
25 AC
26 C
27 A
28 A
29 A
30 D
ocp考试的题目?
感觉这些题目都很好,能给发点类似的题吗?
谢谢