Generally, WHERE EXISTS:Select TWO correct answers.A. is more performant than JOINB. is less performant than JOINC. is interchangeable with JOIND. should be used instead of JOIN for filtering purposes solely

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

Which of the following keyword is equivalent to INNER JOIN?Select one:a.JOINb.LEFT JOINc.None of the answers are correctd.RIGHT JOINe.FULL JOIN

Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?Select one:a.IN operatorb.LIKE operatorc.greater than or equal to operatord.equal operatore.BETWEEN x AND y operator

Which operator is used to join two or more conditions in one of SQL clause?Select one:a.OR , ANDb.INc.JOINd.None of the answers are correcte.BETWEENClear my choice

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.