Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER

Question 1Which of this type of join returns an output of only matching records in the two tables? (Select all that apply)1 pointFULL JOINJOININNER JOINLEFT JOIN

Which JOIN returns all rows when there is a match in one of the tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN

Question 4What will this query return?SELECT *FROM Books_tableLEFT JOIN Biography_table1 pointAll records in Books_table and any matching rows from Biography_tableAll records in both Books_table and Biography_tableAll records in Biography_table and any matching rows from Books_tableAll rows from Books_table joined together with Biography_table

Question 2What is the golden rule for performing SQL joins? (Select all that apply)1 pointFind a related row or record in both tablesFind the linking field or column in both tablesFind the unique and primary keys in both tablesFind a related column or field in both tables

Which JOIN does the following: returns all the values from the right table, plus matched values from the left table or NULL in case of no matching join predicate.FULL OUTER JOININNER JOINRIGHT JOINLEFT JOIN