Question 3How many inner queries can be contained within a nested subquery?1 point361Unlimited10

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

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

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.

Sub-queries can be nested in?UPDATE, DELETE, INSERT and SELECT statements.INSERT statements only.DELETE statements only.UPDATE statements only.

Question 14Indicate reasons for using a nested query in the FROM clause. Multiple answers are possible.1 pointto compute a nested aggregate function, an aggregate function within an aggregate function.to compute independent aggregate functions involving different tablesto demonstrate query formulation ability to colleaguesto simplify some complex decision making queries involving many tables and aggregate functions