which of the following statementsis TRUE about join styles:Cross Product style and Joinoperator style produce different resultsCross Product style is specifiedin the SELECT clauseCross Product style uses INNERJOIN and ON keywordsJoin operator style is specifiedin the FROM clauseSkipSubmit

Which of the following are types of joins in SQL?Answer choicesSelect an optionCross joinNatural joinLeft joinAll of the above

Which of the following SQL keywords is used to perform a Cartesian product in SQL?JOINCROSS JOINUNIONINNER JOIN

he choice of a join style is a matter of preference except for applicability of the join style.1 pointTrueFalse

Which of the following is not true about SQL joins?Group of answer choicesA full outer join returns results of an inner join as well as the results of a left and right join.A left or right outer join returns the results of the inner join as well as the unmatched rows in the left or right table respectively.None of the choicesAn inner join is a join of two tables returning only matching rows.

Which of the following is the correct order of keywords for SQL SELECT statements? SELECT, FROM, JOIN, WHERE FROM, WHERE, SELECT, JOIN JOIN, WHERE, FROM,SELECT SELECT,WHERE,FROM, JOIN