Database programming section 6 quiz

Which syntax would be used to retrieve?
An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria.
The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2='value';.
Which two sets of join keyword create a join that will include unmatched rows?
A left outer join is a method of combining tables.
The result includes unmatched rows from only the table that is specified before the LEFT OUTER JOIN clause.
A right outer join is a method of combining tables.
The result includes unmatched rows from only the table that is specified after the RIGHT OUTER JOIN clause..
Which type of join returns rows from one table that have no direct match in the other table?
A SQL left outer join will return all the records from the left table in the join clause, regardless of matching records in the right table.
The left SQL outer join includes rows where the condition is met plus all the rows from the table on the left where the condition is not met..
The SQL NON EQUI JOIN uses comparison operator instead of the equal sign like \x26gt;, \x26lt;, \x26gt;=, \x26lt;= along with conditions.

Which syntax would be used to retrieve?