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.

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?

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?

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

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

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