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 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 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

When to use SQL WHERE clause?Answer choicesSelect an optionTo limit the column data that are returned.To limit the row data are returned.Both A and B are correctNeither A nor B are correct.

Question 6: (1.00) One of the main rules that subqueries must follow: Subqueries must be enclosed within parentheses Subquery can have multiple columns in the SELECT clause Subqueries that return more than one row can only be used with multiple value operators, such as the >, <,=, >=, <= A subquery can return zero or more rows The BETWEEN operator can be used with a subquery