A) option A is inner join on Borrower and Depositor on customer-name so it will give all customers which having loan and account.
B) SELECT DISTINCT CUSTOMER-NAME FROM BORROWER WHERE CUSTOMER-NAME IN(SELECT CUSTOMER-NAME FROM DEPOSITOR);--> This will also return all different names of customers who taken loans.
C) this is cross product of two tables so it will give many redundant tuples. so this is wrong query according to question requirements.
Ans:C