Question 1 (3 points) The basic format for an inner join using explicit syntax is: SELE.C...FROM table1 JOIN table2 ON join_condition SELE.C.T...FROM table1, table2 WHERE join_condition SELE.C.T...FROM table1, table2 ON join_condition SELEC.T...FROM table1 JOIN table2, join_condition Question 2 (3 points) Correlation names (aka table aliases) can be specified with the option AS keyword to temporarily re-name a table within the scope of the query. When/how is the best practice for using correlation names? They should be used in all queries When there is only one table in the query Always applied to every table in a join When they simplify or clarify the query Question 3 (3 points) When applying multiple join conditions(i.e. more than one condition which must be true) to an inner join in explicit syntax, the extra conditions can be applied: Only in the ON section, connected by AND and/or OR Only in the WHERE clause, connected by AND and/or OR In either the WHERE clause or the ON section, but not both In the WHERE clause and/or the ON section Question 4 (3 points) When performing a self-join (i.e. joining a table against itself), you must apply correlation names to both tables. True False Question 5 (3 points) Which of the following is a correct example of explicit syntax for an inner join of four tables? O s SELECT columns FROM tablel JOIN table2 ON join_conditionl FROM FROM JOIN table3 ON join_condition2 JOIN table4 ON join_condition3 SELECT columns tablel JOIN table2 ON join_conditionl JOIN table3 ON join_condition2 JOIN table4 ON join_condition3 FROM O s SELECT columns FROM tablel JOIN table2 ON join_condition1, table2 JOIN table3 ON join_condition2, table3 JOIN table4 ON join_condition3; O s SELECT columns FROM tablel JOIN table2 ON join_conditionl WHERE table2 JOIN table3 ON join_condition2 AND table3 JOIN table4 ON join_condition3