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

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

When can you NOT use a Type I nested query to perform a join in a SELECT statement?1 pointThe table in the nested query has row conditions.The table in the nested query has a combined primary key.The table in the nested query has an optional foreign key.The table in the nested query provides columns in the result of the outer query.13.Question 13When must you use a Type I nested query in an UPDATE or DELETE statement?

Question 13When must you use a Type I nested query in an UPDATE or DELETE statement?1 pointA non target table has row conditions.A non target table has combined primary key.A non target table has an optional foreign key.A non target table provides columns for the UPDATE statement.

When must you use a Type I nested query in an UPDATE or DELETE statement?1 pointA non target table has row conditions.A non target table has combined primary key.A non target table has an optional foreign key.A non target table provides columns for the UPDATE statement.14.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