In which cases would you use an outer join?Select one:a.The tables being joined have only matched data.b.Only when the tables have a primary key/foreign key relationship.c.The tables being joined have only unmatched data.d.The tables being joined have both matched and unmatched data.e.The tables being joined have NOT NULL columns.

Which of the following join is used to get all the rows from both tables A and B in the resultant table, including those rows that do not have a match in the other table?Answer choicesSelect an optionFull Outer JoinLeft Outer JoinRight Outer JoinNone of the above

Question 10Which of the following is true about FULL OUTER JOIN created on two tables Table 1 and Table 2?1 pointRetrieves only matched rows of Table 1 and Table 2Retrieves the unmatched rows of Table 2Retrieves both matched and unmatched rows of Table 1 and Table 2Retrieves all the unmatched rows of Table 1

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

n which two cases would you use the USING clause? (Choose two)Select one or more:a.The tables to be joined have multiple NULL columns.b.The tables to be joined have columns with the same name and compatible data types.c.The tables to be joined have columns of the same name and different data types.d.You want to create a nonequijoin.

The INNER JOIN clause?Returns all rows that have matching value in the field on which the 2 tables are joined.Returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.Returns all rows from 2 tables.Returns all the matching rows from 2 tables.