Which of the following is one of the basic approaches for joining tables?SubqueriesNatural joinUnion JoinDAll of the above

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

Table A and Table B are to be joined in a query.Which type of join will include all rows from tables A and B in the result?

Which of the following is not a type of JOIN in SQL?

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

Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER