Andre Long
						CISA 320 SQL
						October 14,2004
						final exam


1)  Pre-requisite for problem 6b is 4b

insert into l_employees
values (951, 'Regina', 'Reed', 'MKT' ,'11-nov-2004', 85, null, 201);

select * from l_employees;
select * from Andre;
select * from ex0402a;

now for problem 6b

delete from l_employees
where employee_id = 951;

select * from l_employees;
select * from Andre;
select * from ex0402a;


2)
No Pre=requisites

select table_name, constraint_type, constraint_name
from   user_constraints
where table_name = 'L_DEPARTMENTS';

select*
from user_cons_columns
where table_name = 'L_DEPARTMENTS';