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

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

What are distinguishing features about Type I nested queries? More than one answer is possible.1 pointA Type I nested query does not reference any columns of its outer query.A Type I nested query executes one time for each row of its outer query.A Type I nested query references one or more columns of its outer query.A Type I nested query executes one time and generates a table that can be used in a table comparison operato

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