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

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

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.

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

Which of the following are best practices for queries containing table joins?Select THREE correct answers.A. Join only tables that are really required and used (e.g. in SELECT)B. Filter tables within JOIN instead of within WHEREC. Filter tables within WHERE instead of within JOIND. Use EXISTS when you want to combine columns from two tablesE. Apply a proper filter so that only relevant records are processed