You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?()
A:The main query executes with the first value returned by the subquery.
B:The main query executes with the last value returned by the subquery.
C:The main query executes with all the values returned by the subquery.
D:The main query fails because the multiple-row subquery cannot be used with the comparison operator.
E:You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
出自:Oracle认证