Author Question: Given the tablesSTUDENT(StudentID, StudentName, AdvisorID)ADVISOR(AdvisorID, AdvisorName, Office, ... (Read 59 times)

pane00 · **on:** Jul 7, 2018

Given the tablesSTUDENT(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

Question 2

In XML, a document author can only use the predefined XML tags.

Indicate whether the statement is true or false