Which two statements are true regarding the EXISTS operator used in the correlated subqueries?

Which two statements are true regarding the EXISTS operator used in the correlated
subqueries? (Choose two.)

Which two statements are true regarding the EXISTS operator used in the correlated
subqueries? (Choose two.)

A.
The outer query stops evaluating the result set of the inner query when the first value
is found.

B.
It is used to test whether the values retrieved by the inner query exist in the result of
the outer query.

C.
It is used to test whether the values retrieved by the outer query exist in the result set
of the inner query.

D.
The outer query continues evaluating the result set of the inner query until all the
values in the result set are processed.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Abdulali Aliyev

Abdulali Aliyev

A, C

Taurai Murinda

Taurai Murinda

b,d