This preview shows page 1. Sign up to view the full content.
Unformatted text preview: INTSERSECT query. SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE INTERESECT SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE_1 7. Given the employee information in Question 4, list the query output for the MINUS query of EMPLOYEE to EMPLOYEE_1. SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE MINUS SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE_1 21. What is a trigger, and what is its purpose? Give an example. A trigger is a procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. They can be used for auditing purposes and also for business or security contraints....
View Full Document
- Summer '08