115253 中南大学数据库考试卷及答案.doc

学 院
专业班级
学 号
姓 名
---○---○---
---○---○---
………… 评卷密封线 ……………… 密封线内不要答题，密;
CLOSE c_dept_stat;
END;
3. 使用触发器实现emp表的业务规则：除销售员外，雇员工资只增不减
CREATE OR REPLACE TRIGGER check_sal_emp
BEFORE _______________________________
FOR EACH ROW
WHEN___________________________________
BEGIN
RAISE_APPLICATION_ERROR
(-20504,'除销售员外，雇员工资只增不减!');
END;
4. 创建一个序列，10-200，每次加10，从10开始
CREATE SEQUENCE WORKER_ID
INCREMENT BY ______________MAXVALUE ________START WITH _______________
并使用以上创建的序列，
INSERT INTO EMP VALUES(_____________________,'MARKETING ','HOUSTON');
答案:
ename from emp where empno=(select mgr from emp where ename=’SMITH’)
union
Select ename from emp where mgr=(select empno from emp where ename=’SMITH’);
2. select ename,hiredate,dname from emp,dept where = ;
select ename,hiredate,dname from emp left join dept on = ;
3. select aename from
(select aename, asal, bename, bsal from emp a,emp b where =)
Where asal>bsal;
select from emp a,emp b where = and >;
from emp where deptno=(select deptno from dept where dname=’SALES’);
emp set sal=sal* where job=’MANAGER’;
6. select * from (select * from emp order by hiredate)
where rownum <=