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?

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.

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

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

Which of the following is not a type of JOIN in SQL?

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