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.

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 is a correlated subquery?Select one:a.Uses the result of an outer query to determine the processing of an outer queryb.Uses the result of an inner query to determine the processing of an outer queryc.Uses the result of an inner query to determine the processing of an inner queryd.Uses the result of an outer query to determine the processing of an inner 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 one is not a type of subquery ?

When you have a query inside of another query, the term “subquery” refers to which query?1 pointInnerOuter