Oracle Interview Question

Questions related to ER diagram. 1 SQL Join Query Question. 1 DSA question - Check if a string is present in the other string