Which of the following statements is true regarding subqueries in SQL?Answer choicesSelect an optionSubqueries can only return a single value.Subqueries cannot be used in the SELECT clause.Subqueries can be used in the SELECT, WHERE, and FROM clauses.Subqueries must always use the JOIN clause to relate to the outer query.

Which of the following statements are TRUE regarding subqueries?Answer choicesSelect an optionA subquery can retrieve zero or more rowsA subquery can appear on either side of a comparison operatorThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statementAll of above

Which of the following statements is true concerning subqueries?Question 4Select one:a.Involves the use of an inner and outer queryb.Cannot return the same result as a query that is not a subquery.c.Does not start with the word SELECT.d.All of the above.

Select the correct answerWhich one is not a type of subquery ?OptionsCorrelated Sub queryMultiple row sub querySingle row sub queryVariation based Sub query

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

What are the benefits of using subqueries in SQL? Select all that apply. 1 pointSubqueries make code more readable and maintainable.Subqueries can be nested in a SET command.Subqueries cannot be used within the same query.Subqueries can make projects easier and more efficient.