oracle期末考试题及答案(3)

job列的值转换成大写。

CREATE OR REPLACE TRIGGER biu_job_emp _________________[18]________________ ____________[19]_______ BEGIN

:NEW.job :=______[20]_____; END; 答案 1．A 2．D 3．C 4．A 5．B 6．B 7．B 8．C 9．B 11．C 16．C 21．C 26．A 12．C 17．D 22．C 27．A 13．A 18．B 23．C 28．A 14．B 19．A 24．A 29．B 10．C 15．D 20．B 25．A 30．C 二、填空题（每空2分，共40分） [1] Connect martin/martinpass@aptech [2] Grant select on scott.emp to martin [3] Select * from employee where 1=2 [4] To_char [5] NVL [6] even_number [7] 1..25 SELECT ename INTO empname FROM employee WHERE [8] empno=eno; [9] EXCEPTION [10] OPEN toy_cur [11] FETCH toy_cur INTO my_toy_price; [12] FOR sales_rec IN sales_cur LOOP [13] sales_rec.tsales = sales_rec.asales [14] IN OUT SELECT deptno INTO dept_no FROM emp WHERE [15] empno=emp_no; [16] RETURN result; [17] pack_ma.order_proc(‘002’） [18] BEFORE INSERT OR UPDATE OF job ON emp [19] FOR EACH ROW [20] UPPER(:NEW.job)