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

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?

The UNION SQL clause can be used with ____________SELECT clause onlyDELETE and UPDATE clausesUPDATE clause onlyAll of the mentioned

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

2. Describe the differences between the SQL UPDATE and DELETE statements. When would you use one over the other, and what precautions should be taken?