TA Ch8 - INTSERSECT query. SELECT EMP_FNAME, EMP_LNAME FROM...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 8 Review Questions: 4. Suppose you have two tables: EMPLOYEE and EMPLOYEE_1. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, and Anne McDonald. The EMPLOYEE_1 table contains the records for employees John Cretachakov and Mary Chen. Given that information, list the query output for the UNION query. SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE UNION SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE_1 5. Given the employee information in Question 4, list the query output for the UNION ALL query. SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE UNION ALL SELECT EMP_FNAME, EMP_LNAME FROM EMPLOYEE_1 6. Given the employee information in Question 4, list the query output for the
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online