does EXISTS suppose to return all record if the subquery is true ?

The EXISTS keyword is used to check the existence of any record in a subquery, returning true if the record exists and false if the record does not exist.

For More Info Refer my following blog,

https://www.c-sharpcorner.com/blogs/sql-keyword-exists