In MySQL, what is the purpose of the SQL EXISTS operator?

A. Checks if a table exists in the database

B. Tests for the existence of rows in a subquery

C. Checks if a column exists in a table

D. Tests for the existence of a database

Correct Answer is :

B. Tests for the existence of rows in a subquery