Question

STUDENT 1 StdMajor IS FIN ACCT StdSSN 123-45-6789 124-56-7890 234-56-7890 StdLastName WELLS NORBERT KENDALL StdCity SEATTLE BOTHELL TACOMA StdState WA WA WA StdClass FR JR JR StdGPA 3.00 2.70 3.50 STUDENT 2 StdSSN 123-45-6789 995-56-3490 111-56-4490 StdLastName WELLS BAGGINS WILLIAMS StdCity SEATTLE AUSTIN SEATTLE StdState WA TX WA StdMajor IS FIN ACCT StdClass FR JR JR StdGPA 3.00 2.90 3.40 The following table represents what type of operation that has been performed on STUDENT 1 and STUDENT_2 tables? StdState StdMajor StdClass WA WA StdSSN 124-56-7890 234-56-7890 StdCity BOTHELL TACOMA StdLastName NORBERT KENDALL StdGPA 2.70 3.50 FIN ACCT JR JR O Student 1 UNION Student_2 O Student 1 INTERSECT Student 2 O Student 1 DIFFERENCE Student_2 O Student_2 DIFFERENCE Student 1

Answer 1

ANSWER:

Student_1 INTERSECT Student_2