Given the Tables STUDENT(StudentID,StudentName,AdvisorID)

question 34

Multiple Choice

Given the tables
STUDENT(StudentID,StudentName,AdvisorID)
ADVISOR(AdvisorID,AdvisorName,Office,Phone)
Which of the following SQL statements would be used to implant a join between the two tables?

• A) WHERE STUDENT MATCH ADVISOR
• B) WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID
• C) WHERE STUDENT = ADVISOR
• D) WHERE STUDENT JOIN ADVISOR
• E) WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

---

Definitions:

Negotiation

The process by which two or more parties communicate and come to an agreement or resolve a dispute.

Supreme Court of Washington

The highest court in the state of Washington, responsible for interpreting the state's constitution and laws.

Binding

A legal term indicating that an agreement, contract, or decision is enforceable by law.

Federal District Court

The general trial courts of the United States federal court system where civil and criminal cases are filed.