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.

Which statements are true regarding the USING and ON clauses in table joins? Select one or more:a.The WHERE clause can be used to apply additional conditions in SELECT statement containing the ON or the USING clause.b.Both USING and ON clause can be used for equijoins and nonequijoins c.Maximum of one pair of columns can be joined between two tables using the ON claused.The ON clause can be used to join tables on columns that have different names but compatible data types.

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 conditions has to be satisfied for INNER JOIN to work?a.Columns used for joining can have same or different nameb.Columns used for joining must have same namec.Columns used for joining must have different namesd.Columns used for joining must have different names

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

Question 1Fill in the blank: To combine rows from two or more tables based on a _____ column, data professionals use the SQL JOIN clause.1 point