Given the tablesSTUDENT(StudentID, StudentName, ...

[pane00]

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

[sokh]

Answer to Question 1

E

Answer to Question 2

FALSE

[pane00]

Thanks for the timely response, appreciate it

[kjohnson]

Excellent