What is the meaning of the LEFT keyword in the FROM clause such as Table1 LEFT JOIN Table2?1 pointRetain matching rows from the table to the left (Table1) of the LEFT keyword. Retain non-matching rows from the table to the left (Table1) of the LEFT keyword.Remove non-matching rows from the table to the left (Table1) of the LEFT keyword. Remove matching rows from the table to the left (Table1) of the LEFT keyword.

The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

The FROM SQL clause is used tospecify what table we are selecting or deleting data FROMspecify range for search conditionspecify search conditionNone of theseReview AnswerNext

Which of these is true of LEFT JOIN? (Select all that apply)1 pointAll records from the left table that have no matching record from the right table.It returns all matching records in both tablesAll records from the right table

Which of the following keyword is equivalent to INNER JOIN?Select one:a.JOINb.LEFT JOINc.None of the answers are correctd.RIGHT JOINe.FULL JOIN

Which join refers to join records from the right table that have no matching key in the left table are include in the result set:Full outer joinLeft outer joinRight outer joinHalf outer joinClearMark For Review & NextSave & Mark For ReviewPrevious